LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel 2007 macro: Dialogbox for saving a file as type Microsoft Ex

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007: Saving a file with a Macro Gary Excel Discussion (Misc queries) 1 April 28th 10 03:13 PM
Microsoft Excel 2007, Sharing Violation when saving file Kevin Hendrawan[_2_] Excel Discussion (Misc queries) 1 February 19th 10 11:14 AM
Saving Excel 2007 file in 2003 creates very large file Jon Pearce Excel Discussion (Misc queries) 2 July 16th 09 07:20 PM
Microsoft Excel Viewer 2003 Supported file type Jian Ming Excel Discussion (Misc queries) 2 July 18th 06 04:03 AM
Saving Charts with Microsoft Office 2007 CEMILLER22 Excel Discussion (Misc queries) 1 July 5th 06 07:37 PM


All times are GMT +1. The time now is 08:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"