• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1368
  • Last Modified:

which format do i use for saveas to get Excel8 format?

which format do i use for saveas to get Excel8 format?
I'm trying other format when calling
Excel.Application, perform task and
workbook.saveas filename,fileformat
It's didn't work well if it's not Excel8 format, so what fileformat is Excel8?
0
AStronus
Asked:
AStronus
1 Solution
 
TimCotteeCommented:
FileFormat=xlExcel9795 or 43 if you do not have the enum.
0
 
AStronusAuthor Commented:
still doesno't work corrently with Excel Drivers,most of them able to obtain the value, some return null but at that collumn it's does have value
0
 
xSinbadCommented:
ActiveWorkbook.SaveAs Filename:= _
        "c:\Book1.xls", FileFormat:= _
        xlExcel9795, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
        False, CreateBackup:=False
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
DanRollinsCommented:
Hi AStronus,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept TimCottee's comment(s) as an answer.

AStronus, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
Computer101Commented:
Comment from expert accepted as answer

Computer101
E-E Admin
0
 
symmanCommented:
See also: http://www.convert-files.com/SII/Convert-XLS/English/WebHelp/convert-xls.htm#command_line_manual/file_type_constants/rhid_excel_conversion_file_type_constants.htm

pXlWkBk.SaveAs(Filename:=sWkBookPath, FileFormat:=-4143)

-4143 is (*.XLS) Microsoft Excel 97-2003 Workbook format
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now