General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
VB in Excel.
I have written a VB macro in Excel that does a variety of things, and the final one being to save the file.
What i am trying to do is set the fileformat, however; regardless of the coding i always end up with Save as type "All Types(*.*)".
My VB is as follows:
Do
fName = Application.GetSaveAsFilename
Loop Until fName <> False
ActiveWorkbook.SaveAs Filename:=fName, FileFormat:="Microsoft Excel Workbook(*.xls), *.xls", Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
False, CreateBackup:=False
Any clues?