Opening specified worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot copy worksheet to another file 2
Template on Server 2008 5
Tools / options not available 0
Multiple workbooks to one worksheet 3
Open .xlsx files in Excel 2002 2
Can not open .xls files via Windows Explorer 3
cannot open Excel (.xls) attachments in Outlook 1
Excel 2002: Opening related files by clicking file address 2

Back
Top