Publishing to web..Macro issue

[Scott Zierler]

Hello all!

I have recently upgraded to Office 2003 from Office XP.
Here is my dilemma.

Before the upgrade I had written a macro which would publish a selected
range of cells to a .HTM file using a specified cell as the filename. This
worked wonderfully. Now when I run my macro in office 2003, the resulting
file is a .mhtml file which from what I understand is a MIME encapsulated
HTML file which is a self runinng single web page. However, when I FTP these
to my website for my clients to view they get text, no graphics, colors,
etc...

Please look at the following code which worked correctly in Office XP now
doesnt work in Office 2003.

ActiveWorkbook.PublishObjects.Add( _
SourceType:=xlSourceRange, _
Filename:=Worksheets("Schedule").Range("C4").Value, _
Sheet:="Schedule", _
Source:="B1:F107", _
HtmlType:=xlHtmlStatic).Publish
ChDir "C:\Documents and Settings\ScottZierler\My Documents"

Another thought.....If I record a new macro selecting the cells and save to
the web, the resulting file has a HTM extension, not a MHTML extension as my
previous macro now mysteriously generates.

THANKS FOR YOUR HELP!

Scott