LinkBack URL
About LinkBacks
I need to be able to capture the a workbook's name and then use it within the macro.
I need to be able to capture the a workbook's name and then use it within the macro.
Hi Pablo,
This line of code will give the workbook name:
If you want to capture it in a macro, you could use
Please Login or Register to view this content.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
See if this is what you'r after:
This will refer to cell "A1" in the book that is open, so you can use it in another bookPlease Login or Register to view this content.
Hello Pablo,
If you are looking for a formula to put the workbook's name into cell, you can use this...
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks