Different Month, Different Workbook

  • Thread starter Thread starter abxy
  • Start date Start date
A

abxy

I want particular workbooks to open up when excel starts up depending on
month. For example, everyday that it's Febuary, My Febuary Workbook
opens when excel starts up, then in March, everyday my March Workbook
opens up. Is there any way to do this?
 
You could add code to the Workbook_Open event macro in Personal.xls.
Something like

Workbooks.Open Filename = "My " & Format(Date,"mmmm") & ".xls"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Once a month change the shortcut to Excel parameters.

Right-click on the February workbook in Explorer and "send to desktop as
shortcut"

OR set up a dummy workbook with Workbook_Open code that checks the date and
opens the appropriate workbook then closes the dummy workbook.

Personally I would go for the shortcut change once a month.

Gord Dibben Excel MVP
 
Back
Top