Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Common Dialog Box

Status
Not open for further replies.

LKofman

Instructor
Jun 8, 2003
3
US
I would like to use a common dialog box in vba. It apparently is not bundled with the standard vba load in office 2000. If I have the visual development package loaded though, it shows up in VBA and there's no probelm loading it in the form. Now here's the problem. When I load the excel macro on someone else's machine without visual interdev -- it doesn't find the common dialog box and the program crashes. How can i export the commond dialog box with the excel macro?
 
I was asked this question again by my boss and am still stumped... I think it has something to do with packaging but my skills lie more in backend programming. If anyone can help me out ...
 
Assuming you are using the 32 bit common dialog, just copy the following files to the other users computer...

%systemroot%\System32\comdlg32.dll
%systemroot%\System32\comdlg32.ocx

(Where %systemroot% = C:\WINNT on a W2K System for example)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top