VBA code in Excel 97 vs Excel 2002 
Author Message
 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



Tue, 03 May 2005 00:08:50 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Excel 97 VBA vs Excel 2000 VBA

2. vba code to copy table from access 97 to excel 97

3. Speed of Excel 97 vs Excel 95???

4. Compatibility Problem Using MS Excel 97 VBA on Excel 2000/XP - Causes crashes

5. Excel 97 VBA code for removing references

6. Import From Excel 2000 with VBA code into Access 97

7. VBA 97 to VBA 2K/2002/2003

8. Porting Excel 2000 Toolbars in Win98 to Excel 2002 in WinXP

9. VBA : From ACCESS to EXCEL 2002 !

10. Excel 2002 VBA GetOpenFilename Bug?

11. Exporting VBA Module in Excel 2002

12. Excel 2002 and VBA

 

 
Powered by phpBB® Forum Software