When i open an excel file, two files actually open- the file I clicked on and the hidden Personal workbook. I have a macro saved in my Personal workbook so i can use it across many different files, but in order to do so, i need a way to name the file i actually clicked on, which will be dynamic.
When i use ThisWorkbook.name it references the Personal, not the one I opened.
Ideas???
Hi, Remotruker,
maybe like this:
Or even simpler as the personal workbook should be insvisible: use ActiveWorkbook instead of ThisWorkbook (which holds the code).
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger,
This works!
Thanks!
Originally Posted by HaHoBe
Hi, Remotruker,
maybe like this:
Or even simpler as the personal workbook should be insvisible: use ActiveWorkbook instead of ThisWorkbook (which holds the code).Please Login or Register to view this content.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks