Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to use the current year in a a macro?
I have the following code (partially): Set wkbk = Nothing On Error Resume Next Set wkbk=Workbooks("08Bud 0770.xls") On Error GoTo 0 If wkbk = Nothing then Set wkbk = Workbooks.Open(Filename:"=P:\Excel\2008\08Bud 0770.xls" etc This repeats several times for different files Now I want to copy the file for budget 2009 and all other sub files, changing only the year number. I want, without somebody opening VBE, the macro to work in the new file to. Any suggestions? Cheers, Harold |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date not defaulting to current year | Excel Worksheet Functions | |||
Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
days since 1/1/current year | Excel Discussion (Misc queries) | |||
Current year function | Excel Worksheet Functions | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel |