Opeing an excel file to a specific tab

  • Thread starter Thread starter Darren
  • Start date Start date
D

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
 
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
 
Back
Top