Prompt user to find file & return path as text???? 1

[MrStohler]

I looking for a macro that I can insert into an Excel file to lookup a file path and return the path as text.

Ideally, when the user activates the macro with a button click it would prompt the user, with a dialog box (similar to the "Open" file or "Save as" dialog boxes) to lookup the file (it could be anywhere on a LAN and its name and extension could be different for each user). Once the user selects the file it should place the full path of the file (including name and extension) in a cell as text.

Any help is appreciated.
Thanks

 

[shetlandbob]

There are many posts on this so search, or have a look in the FAQ, clue in the "VBA How To" section

Robert Cumming

http://www.consultantengineer.co.uk

 

[MrStohler]

Thanks for your reply.

I did make several searches of this forum, but most of the replies relate to finding a specific file (I want the user to find the file with an interactive menu simlar to the "Open" dialog box) or an acitive woorkbook.

I wish to find the full path of a file that is selected by the Excel user.

Any thoughts

 

[PHV]

Something like the Application.GetOpenFilename method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shetlandbob]

do I detech an echo coming on.....

FAQ

Robert Cumming

http://www.consultantengineer.co.uk

 

[MrStohler]

PHV, THANK YOU

I knew that I was missing something obvious.