help with a vbs script

[BORUCH]

Hi

I have the below vbs script

Set objExcel = CreateObject("Excel.Application")
objExcel.Application.Run "'C:\Users\jack\AppData\Roaming\Microsoft\AddIns\aaa.xlam'!Module11.dosomething"
objExcel.DisplayAlerts = True
objExcel.Application.Quit
Set objExcel = Nothing

The problem I’m having is that as part of the macro it runs the open file dialog window to select a file and so something with that file, the problem is that if I run the VBS script when i already have windows explorer opened, it opens that file dialog box behind all the open windows it is there anything i can put in the VBS script that will bring it to the front of all open windows ?

Thanks

 

[EFANYoutube]

You may have to do this in the module
Try:

Application.Visible = True

 

[BORUCH]

You may have to do this in the module
Try:

Application.Visible = True

Hi

its not working

the open file dialog box is opening behind all other windows don't forget its not opening the excel application its all via a script in VBS

 

[Joe4]

don't forget its not opening the excel application its all via a script in VBS

I have moved this thread for you to the appropriate forum.
Non-Excel file should be posted to the "General Discussion & Other Applications" forum, not the "Excel Questions" forum.