Using Access 2002, the Set line fails:
Dim dlgSave As Office.FileDialog
Set dlgSave = Application.FileDialog(Office.msoFileDialogSaveAs) ' generates error
Error=445, "Object doesn't support this action"
It works with the other 3 msoFileDialog options, but not SaveAs (and not with a "2" in parentheses.)
Does anyone else get this error?
How can I fix this or what is the best work-around without building my own window?
(If it makes a difference, I'm running on Windows 2000 with service packs up to date.)