Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy workbook and formulas to read to the present month | Excel Discussion (Misc queries) | |||
Change month name in workbook | Excel Discussion (Misc queries) | |||
reset a workbook each month saving a copy and using totals to rest | Excel Discussion (Misc queries) | |||
Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
converting workbook from one month to the next | Excel Discussion (Misc queries) |