How can I click on Excel macro with autogenerated excel file

[Omkar]

Hi

I am trying to click on a macro button in excel using - $oWorkbook.Sheets($Sheet).Activate
$oExcel_1.Run("01_003737-5.xlsm!PixelTime")

I am able to click on the macro successfully but this "01_003737-5.xml" file is autogenerated and every time the filename would be different 

How can I click on that macro with different filename everytime? Any ideas?

Thanks in advance

 

 

[Danyfirex]

It would be great if you can share a working version(modifed) of the Macro/Excel because probably macro has fixed path. 

 

Saludos

[junkew]

You can work with variables if thats what you mean

$fileName="01_003737-5.xlsm" 
$macroName = $fileName & "!PixelTime"
$oWorkbook.Sheets($Sheet).Activate
$oExcel_1.Run($macroName)