Open an Excel sheet an have it go to certain Sheet at bottom

[DougP]

We have Excel sheets that have many Sheet TAB's at the bottom. Is there a way to create an autoexec macro or something and pass a parameter to it that will make Excel open the spreadsheet then click the Sheet TAB called Results by passing the word "Results". Or open the same Excel spreadsheet and have it go to Items Sheet or the by passing the word "Items" in the command line?

Hope this make sense.

TIA


DougP, MCP, A+

 

[VulcanJedi]

to open a workbook and pass a switch/parameter before loading excel would require vbs/wsf file but yes more than possible
or autostart macro can be launched from that particular file.

Tranpkp

 

[xlhelp]

Hi, Doug

This belongs in Forum 707

Member- AAAA Association Against Acronym Abusers

 

[DougP]

thank you


DougP, MCP, A+