Common Dialog Alternatives Challenge 2

[ssVBAdev]

Okay! I think I'm giving up on the Common Dialog problems I'm having (see the thread "Common Dialog Problems (comdlg16.ocx)) so here's the challenge...

I have a VBA project in a Microsoft Excel Document that I distribute to other users. There is a need for the users to "open" and (sometimes) "save" external files that are separate from the .xls file (like .txt files for instance). Now, I wanted to use the "Common Dialog" to make the program user friendly and reletively easy to program. I have the "Common Dialog" referenced into the project but when I distribute the .xls file, users who do not have the comdlg16.ocx file registered on thier computers, the "open" does not work.

1) How can I send them a "patch" to either fix the comdlg.ocx problem or hjave them download the proper files or,

2) How can I, as the developer, enable users to "open" or "save" external files easily (similar to the common dialog with a navigational style browser to find files)?

Any thoughts??

 

[psemianonymous]

The code is hosted on an MS Access site, but it will work with Excel as well as other programs that support VBA:

http://www.mvps.org/access/api/api0001.htm

Call the function GetOpenFile instead of using the control.

 

[ssVBAdev]

Well, I've reviewed the code but I'm not fluent in access VBA. My strengths are Excel. I get an error on the line:

If IsMissing(hwnd) Then hwnd = Application.hWndAccessApp

The hWndAccessApp is obviously not a reconized Property of the Application object in Excel. Is there an excel version of this code available or can it be easily translated for Excel?

 

[ssVBAdev]

Well, I'm back to using the "Common Dialog" thanks to sdraper. Thanks for your time foolio12.