compile error in module

  • Thread starter Thread starter Zygoid
  • Start date Start date
Z

Zygoid

I have a short cut on two computers that goto my excel2002 speadsheet o
a third computer.

I have a commandbutton on the spreadsheet to open a filedialaog;

module4 general _OpenFiledialogWindow

Sub OpenFiledialogWindow()
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
fd.InitialFileName = "\\greg\greg\bids\"
fd.Show
End Sub


One computer with the shortcut works fine, but the other returns a
error;

Compile error:
User-Defined type not defined

Any help would be appreciated. Thank
 
I think you need to check Tools/References in the VB Editor - th
problem PC probably does not have the necessary one checked
 
FileDialogs were added in xl2002. Are you sure all 3 pc's are using at least
xl2002?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filedialog problem 2
Error trap only works once 2
a compile error 6
Excel macro to add an hyperlink that shows only the filename (no p 1
File Dialog Picker 1
Exists FileDialog in VBA OutLook? 1
Show file dialog box 1
open file from folder save in new folder 20

Back
Top