Macro working with Excel not with a XML data file
Studio Manager / Evolve license type
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"
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
You can still publish a VBA encrypted scripts to Studio Manager and use it locally
This might help for the Excel to XML conversion: