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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
