Browse Button 1

[UnsolvedCoding]

Hey all - I have been instructed to add a browse button to an application that functions muck like the open button in Excel.

This thread

http://tek-tips.com/viewthread.cfm?qid=938499

went over some of that but didn't really cover what I am trying to do.

I need to let the user click the button, browse to the desired folder or file and then use that path in the code. If possible I would like some sort of text box or to populate a cell with the path so that the user could see the actual location.

How do I do this?

 

[SkipVought]

hi,

Check out the GetOpenFileName Method.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[UnsolvedCoding]

Thanks Skip.

 

[UnsolvedCoding]

Quick Question -

Is there such a thing as getfilepath that would allow me to get and copy the path to a file using a similar method to GetOpenFileName?

 

[SkipVought]

You can parse the path from any file obtained using this method.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}