Description

Macro working with Excel not with a XML data file

Applies To

Studio Manager / Evolve license type

Cause

Not supported

Our online guide covers only Excel format with the following location of the script

1- from a specific location on your machine
strShuttleFile = "C:\Table_20140930_143519.qsq"
 
2- embedded to your Excel macro enabled template with a Studio Manager/Evolve license
StudioMacros.LibraryName = "Query"
 
3- embedded to your Excel data file with a Connect license
StudioMacros.PublishedFile = "Table_20150113_150602"

Solution

VBA is a language used to write Macros, it is not linked to Excel 
Our online document is only with Excel and that is what we support: https://docs.winshuttle.com/studio-en-20-2-online-help-studio-with-evolve-studio-manager/use-macros-to-run-query-script.htm?tocpath=Studio%2020.2%20Online%20Help%7CQuery%7CRun%20Scripts%7C_____4

However, an expert in VBA should be able to run Winshuttle from another format

Additional Information

You can still publish a VBA encrypted scripts to Studio Manager and use it locally 

This might help for the Excel to XML conversion:
https://analysistabs.com/vba/code-convert-excel-to-xml/