Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not saving as xls file
Hi all,
I am using Excel 2003 with Vista. I have an Import/Export routine creating and saving data in a new workbook. The New WkBk is being "SaveAs, xlNormal". The problem I have is that it is being saved in a non recognisable format and I am requested to chose a program to view it with. In the File Open form I cannot see the file until I activate Files of Type All Files. When I change the extension to ".xls" I can view the file in the File Open and can open the file in Excel. It is saved as an Excel file. . Has anyone come across such a problem? Have I inadvertantly triggered something in my code? Many thanks/sgl |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not saving as xls file
please show the code
if the workbook is assignt to WB ( a workbook object) then your code should be WB.SaveAs sFileName where sFilename contains the name as text excluding the ".xls" "sgl" wrote in message ... Hi all, I am using Excel 2003 with Vista. I have an Import/Export routine creating and saving data in a new workbook. The New WkBk is being "SaveAs, xlNormal". The problem I have is that it is being saved in a non recognisable format and I am requested to chose a program to view it with. In the File Open form I cannot see the file until I activate Files of Type All Files. When I change the extension to ".xls" I can view the file in the File Open and can open the file in Excel. It is saved as an Excel file. . Has anyone come across such a problem? Have I inadvertantly triggered something in my code? Many thanks/sgl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
saving an excel file as an ASCII text file without delimiters | Excel Programming |