Hi,
I have a problem with Microsoft XML library when migrating to Excel 2010.
I currently have XLS and XLA files with vba code containing the following variable definition:
Dim oXmlHttp As New MSXML2.XMLHTTP50
In the VB Editor > Tools > References, I have a reference to Microsoft XML v5.0
This currently works fine on Excel 2003 and Excel 2007.
On Excel 2010 installations, sometimes Microsoft XML v5.0 is not present, and only Microsoft XML v6.0 is present. To use the v6.0 library, I'll have to change the reference of my VB project as well as change the variable definitions in all my code to
Dim oXmlHttp As New MSXML2.XMLHTTP60
My question is: how do you write one addin with code that can be used on Excel 2003, 2007 and 2010?
Thanks,
Sam
I have a problem with Microsoft XML library when migrating to Excel 2010.
I currently have XLS and XLA files with vba code containing the following variable definition:
Dim oXmlHttp As New MSXML2.XMLHTTP50
In the VB Editor > Tools > References, I have a reference to Microsoft XML v5.0
This currently works fine on Excel 2003 and Excel 2007.
On Excel 2010 installations, sometimes Microsoft XML v5.0 is not present, and only Microsoft XML v6.0 is present. To use the v6.0 library, I'll have to change the reference of my VB project as well as change the variable definitions in all my code to
Dim oXmlHttp As New MSXML2.XMLHTTP60
My question is: how do you write one addin with code that can be used on Excel 2003, 2007 and 2010?
Thanks,
Sam