I have a macro that opens and closes other work books so I have a statement to activate the workbook that has the macro.
Workbooks("Current.xls").Activate
The thing is, this file gets saved ever now and then as a newer version, and I have to change that file name Current.xls to the new name every time I run that macro. How can I stop from having to do this? Something like
ActiveWorkbook = ThisVersion
Workbooks(ThisVersion).Activate
Or
Dim ActivateThisFile as String
ActivateThisFile = ????
Workbooks("Current.xls").Activate
The thing is, this file gets saved ever now and then as a newer version, and I have to change that file name Current.xls to the new name every time I run that macro. How can I stop from having to do this? Something like
ActiveWorkbook = ThisVersion
Workbooks(ThisVersion).Activate
Or
Dim ActivateThisFile as String
ActivateThisFile = ????