Hello Everyone!
Is it possible to import a file name into header? The catch is that the file name that I need is not the file name of the workbook I am in. I have seen ways it can be done but they bring the entire file path instead of just the file name. I would like to be able to use this method to point to file to grab name from.
Thank You.
Please Login or Register to view this content.
Last edited by mkelsay91; 10-29-2013 at 07:46 AM.
Hi,
and where is the file you want to bring in, I mean, if its opened it might work, but if its not opened nor mentioned anywhere else I dont see much of a chance to get the name of the file without using the whole filepath
best regards
Soul
I was planned on using this to point to the file to grab name from.
Please Login or Register to view this content.
So the file is actualy opened, so that one might work....Btw. rereading what you wrote at the first post IŽve missed on one thing, i thought that youŽre refering to the process where they actualy need the path to the file to address your issue, but rereading it again it seems like they are doing what you want just they have the path in the place where youŽd like to see only the path name, in that case I suggest a loop that removes all the / from the string and than only the last one remains
EDIT: got some meeting now but IŽll provide a code for the loop afterwards (1-2 hours), ps just let me know if my last thought process is correct
Last edited by SoulPrisoner; 10-29-2013 at 07:59 AM.
you can get the name from the full path
for instancePlease Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Yeah. So basically I import this data, into my spread sheet that has a macro.
I have to import the File Name of where my I pulled that Data, into a the right header.
So I would need to filter all this "C:\Users\Matt\Downloads" out. However I can't be that specific as this is used on multiply Computers and don't follow my exact directory.
I hope I am not making this sound confusing.
Do you know of how I can tell it to place pulled name into right header?
add
Please Login or Register to view this content.
Thank You! I will marked as Solved!
Hm, just came from the meeting and i can see that issue already solved, well, GJ
cu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks