Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007: Saving a file with a Macro | Excel Discussion (Misc queries) | |||
Microsoft Excel 2007, Sharing Violation when saving file | Excel Discussion (Misc queries) | |||
Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 Supported file type | Excel Discussion (Misc queries) | |||
Saving Charts with Microsoft Office 2007 | Excel Discussion (Misc queries) |