Help with open file dialog creation

[snypa]

Hi

I've been trying to create an open file dialog box and I can't get it to pop up. Is there a module I need to create and if so how do I do it. I'm able to import the file using the transferspreadsheet command but I want the user to be able to browse the filesystem and select the file

Thank you

 

[HiTechCoach]

I find this very useful:

Call the standard Windows File Open/Save dialog box

Hope this helps ...

 

[snypa]

Thanx for that I gave that a shot earlier on today, I'm getting the following error, "User defined type not" besides calling the function in testit in my code is there anything else I need to do??

 

[HiTechCoach]

Thanx for that I gave that a shot earlier on today, I'm getting the following error, "User defined type not" besides calling the function in testit in my code is there anything else I need to do??

You need to place ALL of the code in a code module. The TestIt() function is only an example of the code you could use in your own command button.

 

[HiTechCoach]

I put together a quick example for you.