CMYACHTIE
asked on
Word 2002 SP3 SaveAs FileDialog macro code problem
I got this from the VBA Help of Word 2002:
This example displays the Save As dialog box.
Sub ShowSaveAsDialog()
Dim dlgSaveAs As FileDialog
Set dlgSaveAs = Application.FileDialog( _
FileDialogType:=msoFileDia logSaveAs)
dlgSaveAs.Show
End Sub
This creates two problems for me:
1) It displays the SAVE and NOT the SAVEAS dialog, anyone know why?
2) When I type in the filename to save the file as, the file is NOT saved as such, anyone know why?
Hope you can shed some light on this for me VBA is not my forte
TIA
This example displays the Save As dialog box.
Sub ShowSaveAsDialog()
Dim dlgSaveAs As FileDialog
Set dlgSaveAs = Application.FileDialog( _
FileDialogType:=msoFileDia
dlgSaveAs.Show
End Sub
This creates two problems for me:
1) It displays the SAVE and NOT the SAVEAS dialog, anyone know why?
2) When I type in the filename to save the file as, the file is NOT saved as such, anyone know why?
Hope you can shed some light on this for me VBA is not my forte
TIA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It's been very frustrating
Thanks for you help