Macro Save Workbook Name for (Re)Activate

[ChuckRobert]

I am trying to run a macro from workbook A that opens workbook B (containing appointments), copies required data and paste it into workbook A.

The challenge I have is that workbook A is renamed each week as 05/18/2009.xls....05/25/2009.xls. (etc.) so if I hard code the re-activate workbook A (to paste) with the current workbook name will not work next week once re-named.

Could I get a suggestion on code that would enable the Macro to first look for the current workbook name, then use that reference to re-activate the sheet later in the code?

 

[Norie]

Well don't hardcode and don't 're-activate'.

Create a reference to the workbook (A?) the code is in like this:

Set wbThis = ThisWorkbook

You can now use this in the rest of the code whenever you want to refer to that workbook, for example to activate it.

wbThis.Activate

But you shouldn't need to activate anyway, but that's hard to tell without seeing some of your code.

 

[ChuckRobert]

Perfect and simple - thanks!!