compile error in module

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
 
B

BrianB

I think you need to check Tools/References in the VB Editor - th
problem PC probably does not have the necessary one checked
 
D

Dave Peterson

FileDialogs were added in xl2002. Are you sure all 3 pc's are using at least
xl2002?
 
Top