Hi all,
I'm currently using the following code:-
The variable PathName is a Variant as it can also be an array from selecting multiple file.
Please Login or Register to view this content.
What I am trying to do is extract the path to the file and store as a string
I do not wish to invoke the GetOpenFilename again - Is there a simple way to do this?
Thanks in advance
Steve
Last edited by Retec123; 08-25-2010 at 07:51 PM.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Hi shg,
Sorry.. I probably didn't make it quite clear..
The path where I direct Application.GetOpenFile is not where my .xls resides..
I am trying to read the path name as a string from the App.GetOpenFile variable 'PathName' because I wish to automatically select files at that destination to read their filename without having to use the App.GetOpenFile again..
Self answered as follows.......
Many ThanksPlease Login or Register to view this content.
Last edited by Retec123; 08-25-2010 at 07:53 PM.
Glad you got it sorted.
Would you please take a few minutes to read the forum rules, and then edit your post to add CODE tags?
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks