Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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.



.

Reply
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



All times are GMT +1. The time now is 12:36 PM.

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

About Us

"It's about Microsoft Excel"