I'm trying to write code that will look at the filepath of the workbook I am currently in and enters it into a given cell (say A1) for reference in the following code:
In other words, the file path you see above, I need to generate that automatically so that no matter what file I am in the Macro can be run.... hope this makes sense!
Please Login or Register to view this content.
Thanks guys!
Last edited by jrodlc08; 07-16-2010 at 02:04 PM.
... return the path.Please Login or Register to view this content.
Please change your QUOTE tags to CODE tags.
Entia non sunt multiplicanda sine necessitate
Let me show you my entire code and tell you a little more about what I'm trying to do. What I am doing is taking an open Workbook with multiple tabs, stripping out neccessary data and pasting it into a NEW workbook, save the new document as the same name as the Master file I have stripped the data from all under Macro control. What I would like to do is take the file path of the exisintg file and have it dumped into a cell in the Master file and then copied into the NEW workbook that contains the stripped out data and then instead of my hard coded path you see below at the bottom of the code, have that reference the cell that the filepath has been copied to as the new name. I'm very new to all of this and I'm sure there is a much easier way to go about doing this so all help is greatly appreciated.
Please Login or Register to view this content.
anyone have any help for me on this one??
I'm not really clear on why shg's answer doesn't help you?
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks