Thanks for the reply. I used to be able to connect directly to a SQL Server
database and bring the data automatically into Excel but now I have to go
through a terminal server to access the data so I was hoping to create web
services to the data on the SQL Server and consume them in Excel.

"Fredrik Wahlgren" wrote:


"djb" wrote in message
...
Is it possible to consume web services in Excel using vba or do you need
to
use .NET?
--
djb

Maybe. I wouldn't recommend it. I think you would need VB6 or .Net code that
in turn calls Excel. Microsoft has recommended against using Excel as a
server application. Can you please tell more about what you want to do?

/Fredrik