I have created a simple VBS script to automate running a Macro against a file, however this sets a specific file name, how can I adapt this VBS script so that it funs the same Macro name for all .xlsm files in a specific folder?
Set objExcel = CreateObject("Excel.Application")
objExcel.Application.Run "'C:\New Name Test\Testv3\Files\TestfileConvertCreate.xlsmx'!CreateUniqueContainers"
objExcel.DisplayAlerts = False
objExcel.Application.Quit
Set objExcel=Nothing