Sorry for the post in the wrong forum, my bad.

Thanks JRL that opening switch on Excel.exe was the trick thanks so much for everyone's help!

Bob

I receive a read only spreadsheet daily that I am scripting to open, change tabs and then save as an ASCII text file. Everything is working fine except telling the spreadsheet I want it to open read only. Below is an excerpt of my script and I have bolded where I try to press the hot key in the wind...

Thanks idiot (that sounds funny) and JRL the waitwindow open worked perfectly thanks so much.

I will be checking into the vkcode stuff though.

Have a great day

Bob

I have a simple script trying to change to another tab on an excel spreadsheet and to do that requires a CTRL Page Up command. Below is my script and I can't get the CTRL to be recognized and pressed in teh macro. Thanks for an education execute file>todaysfile.xls setfocus>Microsoft Excel - todaysf...