Excel and COM
 

I'm trying to use the SaveAs method and just trying to
find out what filetype # HTML is so i can use it with php.

ex:
$book - SaveAs("C:\\test.htm","xlHTML");
the above does not workhowever.

$book - SaveAs("C:\\test.htm",6);
6 is it for Word i think, but not excel.

Thanks in advance.

Excel and COM
 

Randy,

The xlHTML file format constant. is 44. The value 6 is for CSV.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Randy" wrote in message
...
I'm trying to use the SaveAs method and just trying to
find out what filetype # HTML is so i can use it with php.

ex:
$book - SaveAs("C:\\test.htm","xlHTML");
the above does not workhowever.

$book - SaveAs("C:\\test.htm",6);
6 is it for Word i think, but not excel.

Thanks in advance.

Excel and COM
 

Worked like a charm. Thanks very much.

-----Original Message-----
Randy,

The xlHTML file format constant. is 44. The value 6 is
for CSV.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Randy" wrote in
message
...
I'm trying to use the SaveAs method and just trying to
find out what filetype # HTML is so i can use it with
php.

ex:
$book - SaveAs("C:\\test.htm","xlHTML");
the above does not workhowever.

$book - SaveAs("C:\\test.htm",6);
6 is it for Word i think, but not excel.

Thanks in advance.


.