G
Guus
Hello,
I just have upgrated from Excel 2003 to Excel 2007.
I had in Excel 2003 a macro who import a text file, and saved it as an
Excelfile.
1. The macro opens a textfile using a dialogbox
2. The macro has to show a dialogbox, where the filename (without extension)
will be the same as the textfile, but the suggested FileType has to be
'Excel'.
3. Because the macro opens a textfile, the following VBA-code needs an extra
argument.
Application.Dialogs(xlDialogSaveAs).Show File
My question:
Who can help me to complete the just mentioned VBA-code to fill the "Save as
Type" in the dialogbox as 'Excel Workbook (*.xlsx)"
Thank you in advance,
Guus
I just have upgrated from Excel 2003 to Excel 2007.
I had in Excel 2003 a macro who import a text file, and saved it as an
Excelfile.
1. The macro opens a textfile using a dialogbox
2. The macro has to show a dialogbox, where the filename (without extension)
will be the same as the textfile, but the suggested FileType has to be
'Excel'.
3. Because the macro opens a textfile, the following VBA-code needs an extra
argument.
Application.Dialogs(xlDialogSaveAs).Show File
My question:
Who can help me to complete the just mentioned VBA-code to fill the "Save as
Type" in the dialogbox as 'Excel Workbook (*.xlsx)"
Thank you in advance,
Guus