View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John M[_2_] John M[_2_] is offline
external usenet poster
 
Posts: 5
Default Assign "Get External Data" from a VSTO Add In

Hello,

I would like to be able to assign a web service as external data for a
Worksheet. I need this to be done through a VSTO add in for the Ribbon in
Excel 2007.
The code might look like:

public void XMLAttachment()
{

this.Sheet.GetExternalData.WebServiceURL("https://someService.asmx/getData?startMonth=200708");
}

I want the Excel sheet to load the XML exactly as it does when this is done
through the User Interface.

Thanks in Advance,
John M.