Duckbill32
New Member
- Joined
- Dec 28, 2022
- Messages
- 9
- Office Version
- 2021
- Platform
- Windows
Hi everyone,
I am wondering how to open SaveAs dialog box so, that the saving file format would already be preselected as Excel Workbook (.xlsx), even if the original file has different extension.
I can open SaveAs window with this code, but how to preselect the formatting?
Thanks!
I am wondering how to open SaveAs dialog box so, that the saving file format would already be preselected as Excel Workbook (.xlsx), even if the original file has different extension.
I can open SaveAs window with this code, but how to preselect the formatting?
VBA Code:
Application.Dialogs(xlDialogSaveAs).Show
Thanks!