It doesn't look like that there are command-line switches that select the sheet. The only way I KNOW of is to put it in a Workbook_Open event or Auto_Open macro. If you don't "own" the file, you could create one of your own that, when opened, opens the second file and selects the sheet.
paul ________________________________ From: RCGUA <stv.nels...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Tuesday, June 16, 2009 6:18:30 PM Subject: $$Excel-Macros$$ How can I open that workbook to a specific workSheet from a shortcut or batch file outside of Excel? I have a shortcut on my desktop that will open a specific workBook in Microsoft Excel 2003. How can I open that workbook to a specific workSheet? For example, "sheet3" I need to use a shortcut or some sort of batch file because I am running it from a fingerprint reader. The fingerprint reader is UPEK Digital Privacy Manager http://www.upek.com/solutions/eikon/default.asp and the software is called Protector Suite, it allows for a path to the application file and another box for "parameters", but, I can't make it open a specific worksheet. The path for my shortcut is below. The fingerprinter will trigger the shortcut and launch Excel and open the workbook to whatever sheet was opened last.. "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /r "c:\data \myworkbook.xls" Does anyone have any ideas? Maybe some sort of script or batch file? Thanks --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
