PC Review


Reply
Thread Tools Rate Thread

Assign "Get External Data" from a VSTO Add In

 
 
John M
Guest
Posts: n/a
 
      1st Oct 2008
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the "VSTO way" for loading data into variables at run time Don Microsoft Excel Programming 0 6th Dec 2007 11:43 PM
"external data sources" and "external data ranges" TS Microsoft Excel Discussion 0 30th Oct 2006 10:08 PM
Getting "you tried to assign the null value to a variable that is not a variant data type" error with MS template Jess Microsoft Access Form Coding 11 27th Jun 2006 02:51 PM
"Edit Query" control in the "External Data" toolbar curiousaboutexcel Microsoft Excel Programming 0 25th May 2006 06:26 PM
how to assign a "hot-key" or "Macro" to Word "strikethough" feature =?Utf-8?B?TWlrZQ==?= Microsoft Word Document Management 3 5th Dec 2003 10:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:48 PM.