Error in FileDialog

[sailor_123]

I am using Access 2003.

The following code from VBA "help file" generates an error, "Expecting user
defined type not project".

If I am not adding a reference then please tell me exactly what to add and
how.

Your help will be greatly appreciated.


Dim dlgSaveAs As FileDialog

Set dlgSaveAs = Application.FileDialog( _
FileDialogType:=msoFileDialogSaveAs)

dlgSaveAs.Show

 

[Ken Snell \(MVP\)]

Look at this Microsoft Knowledge Base article:
http://msdn2.microsoft.com/en-us/library/aa195878(office.11).aspx

 

[sailor_123]

The comment in the code to add reference on to "Microsoft Office 11.0 Object
Library" was the secret.

Thanks for the reply.