Opeing an excel file to a specific tab

[Darren]

Any ideas on how this can be done with a command line. ie
c:\excelfile.xls:specific_tab or
c:\excelfile.xls@specific_tab
something simple like this.
Thanks
Darren

 

[Frank Kabel]

Hi
you can put some yode in the workbook_open event of your
workbook. put the following in yur workbook module

sub Workbook_Open()
me.worksheets("specific_tab").activate
end sub