Hi,
In Excel I call various wsdl's. I create the "stubs" by installing SOAP 3.0 on the PC and then within VBA go to Tools/Add Web Reference which works fine.
I have just purchased Office 2007 and when trying to download Soap I saw that it has been discontinued and is replaced by .NET. Despite installing .NET framework I can not get the "Web Service Reference" tab within VBA for Excel 2007. I admit the whole of the new Excel looks totally different, but even going through the Data/Connection links I was unable to get anywhere.
Any clues of how to link to WSDL's from Excel 2007/VBA (and to generate stubs for it)?
Many thanks in advance
In Excel I call various wsdl's. I create the "stubs" by installing SOAP 3.0 on the PC and then within VBA go to Tools/Add Web Reference which works fine.
I have just purchased Office 2007 and when trying to download Soap I saw that it has been discontinued and is replaced by .NET. Despite installing .NET framework I can not get the "Web Service Reference" tab within VBA for Excel 2007. I admit the whole of the new Excel looks totally different, but even going through the Data/Connection links I was unable to get anywhere.
Any clues of how to link to WSDL's from Excel 2007/VBA (and to generate stubs for it)?
Many thanks in advance
