Different Month, Different Workbook
 

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?


---
Message posted from http://www.ExcelForum.com/

Different Month, Different Workbook
 

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)

"abxy " wrote in message
...
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?


---
Message posted from http://www.ExcelForum.com/