I'm trying to use the File Dialog property to get input from a user to get the name and location to create a exported spreadsheet.
I can export the spreadsheet fine. Here is the problem.
Here is the code:
Dim dlgSaveAs As FileDialog
Set dlgSaveAs = Application.FileDialog( FileDialogType:=msoFileDialogSaveAs)
Here is the error - the Dim statement is where the error is happening
User-Defined type not defined
Can anybody help?
Thanks in Advance