Import data from webservice

[Steven Doka]

I've got a web service and I'm looking for a way for my users to easily
consume those services in Excel. So..after scanning the Excel help and
visiting MSDN I'm still stumped. How do you do it without having to write
VBA code?

Steven

 

[Harlan Grove]

I've got a web service and I'm looking for a way for my users to
easily consume those services in Excel. So..after scanning the
Excel help and visiting MSDN I'm still stumped. How do you do it
without having to write VBA code?

I believe you'd need to write an interface for your web service that would
allow Excel to use web queries to 'consume' it.