Switch back to original workbook within macro

**theletterh** · 03-04-2013, 01:15 PM

Hello all,

Attempting to run a macro from workbook A ("Feedback_View_(Perspective)_2013-03-04-0950.csv") where data from workbook B ("Helper.xlsx") is copied and pasted into a new worksheet named "Helper" in workbook A. Here is my code so far:

Please Login or Register  to view this content.

This code works, however I would like it to work for other "destination" files, which will have a different date/time stamp.

Any help would be much appreciated!

**Norie** · 03-04-2013, 01:47 PM

You could change the code so it doesn't need to switch workbooks.

Please Login or Register  to view this content.

**xladept** · 03-04-2013, 03:19 PM

Something like this??

Please Login or Register  to view this content.

**theletterh** · 03-04-2013, 03:39 PM

Thanks Norie,

That worked beautifully. As a follow up, if I save this macro in my hidden PERSONAL.XLSB, what adaptation to the macro ought I make such that the new "helper" tab gets created in the workbook that I have open?