
VBA code in Excel 97 vs Excel 2002
We had a contractor that created vb code behind an Excel
spreadsheet that would create the excel spreadsheet in
html format. This was originally created in Office 97.
Now we are moving over to Office 2002 running on Win XP
boxes.
Problem: When I run the SaveAsHtml script, it is rather
long, I look at the created html file and there seems to
be lots of xml code stuffed into it.
This is just a sample of what is added to the top:
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns=" http://www.*-*-*.com/ ;>
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns=" http://www.*-*-*.com/ ;>
<head>
<title></title>
<link rel=File-List href="test_files/filelist.xml">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
x\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style
id="[List of upcoming patches_dw_test.xls]List of
upcoming patches_dw_test.xls!$A$1_$M$9_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl2320720
{padding:0px;
mso-ignore:padding;
color:windowtext;
font-size:8.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
mso-background-source:auto;
mso-pattern:auto;
white-space:normal;}
.xl2420720
{padding:0px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:center;
vertical-align:middle;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
I do not know how to get around this. If I run the same
vb code script on the Win NT box, Office 97, it works
great, move over to XP and I get this stuff. I is not
formatted the same nor will it fit in my table forms that
are created. How do I disable this XML stuff MS has
created?
ADD_INS: Internet Assistant VBA is checked.
Thanks. I am my wits end.
Ddwebb