VBA Macro to update or replace current name of file in code?

[Cosmos75]

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 = ????

 

[Russell Hauf]

If I'm understanding you correctly, you can do something like this:

Dim wbk as Workbook

Set wbk = ThisWorkbook

'... your code

wbk.Activate

___________________________

Hope this helps,

Russell