Defining workbooks with random file names

[ExcelFTW]

Hi,

One of my macros stored in my PERSONAL.XLSB when run, opens an excel workbook that I use as a template and copies data back to whatever workbook I'm on at the moment. My issue is, I run this macro on random excel workbooks. Because of this, the name of the workbooks that I run this macro on are never the same. How can I define the current workbook that has the random file name/location, so that I can after copying the data from my template go back to this random workbook?

[rylo]

Hi

When the "random" workbook is selected, use a variable in the macro in the form of

Please Login or Register  to view this content.

That way, you have a reference to the workbook that you can use to either reference it, or go back to it....

rylo