How can I add a WebService reference to an Excel 2010 sheet?
I know in Excel 2003 I should only go to: Microsoft Visual Basic Editor click: Tools > Web Service Reference…
Ok, I know I can go to VBE and create a class module and a regular module and do it all by using SOAP, but as it was a lot easier on Excel 2003 by simply using "Web Services References" I ask if there is still a way of using it in Excel 2010.
Any clues?