Opening specified worksheets

P

Pugwyrm

Is there a way to open a .xls file on specified worksheet? For example, I've
a file with 4 sheets, each one has a different week of the month. I tried
writing a .bat file to start Excel, open the .xls file and change the sheet
depending on which week we were on - nothing too complex but didn't work. Any
ideas please?
 
R

routeram

If you are comfortable with macros, you can probably write a progra
that identifies the week from today's date and select the appropriat
worksheet tab. This would be in the workbook_open procedure of th
workbook. (Ofcourse you will have to enable macros each time with
click
 
Top