Re: Web services

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Oct 6, 11:40 pm, "Dana DeLouis" <ddelo...@xxxxxxxxxxxxx> wrote:
I'm trying to pull off data from a website application that supports
API calls.

Hi. I've looked into this also, but didn't have much luck. Mainly because
it's over my head.
It's a little easier to do in Math programs, but it's still way over my
head.

For example, to load Google, all I need to do is:

InstallService[http://api.google.com/GoogleSearch.wsdl];

If you can understand The GoogleWebAPIs at the above link...Wow!!

I don't think Excel will make it that easy.
So, once loaded, I did...

GoogleSearch["Excel WebServices", MaxHits -> 10]

http://blogs.msdn.com/excel/archive/2005/11/17/493962.aspx

http://msdn2.microsoft.com/en-us/library/ms572330.aspx

etc...

So, apparently it is possible. Looks like it is done through Share PointServices.
If you can figure it all out, please let us know. :>O
Good luck.
--
Dana DeLouis

"Leith Ross" <LeithR...@xxxxxxxxx> wrote in message

news:1191698758.832186.290120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On Oct 6, 10:21 am, Ed Peters <edpeters...@xxxxxxxxxxx> wrote:
Hi,

I've been searching around for info onwebservicesusing VBA and
there does not seem much about or its a few years old... although it
does seem possible...(found the Microsoft SOAP library).

I'm trying to pull off data from a website application that supports
API calls.

Thanks,

Ed

Hello Ed,

That's a pretty sketchy post. Can you be more specific about which
application you are referring to, and what type of information you
want to retrieve? Do you need to log on into this site? What version
of Excel and Windows are you using? This important when working with
API calls.

Sincerely,
Leith Ross- Hide quoted text -

- Show quoted text -

Thanks, I use Excel 2003 and XP pro / 2000 and would need to login
(it's a shopping site).

However on further research I don't think Excel is the easist or best
way forward for webservices.

Thanks,

Ed

.

Relevant Pages

  • Re: Web services
    ... API calls. ... but didn't have much luck. ... it's over my head. ... I've been searching around for info on web services using VBA and ...
    (microsoft.public.excel.programming)
  • Re: Missing "export to spreadsheet" option
    ... I can't remember off the top of my head, but I believe there are a ... couple lists that cannot be exported to Excel. ... another list using the Microsoft.SharePoint API ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Cannot get code to work for API Save Dialog Box
    ... You can put it in the same Standard module with DetectExcel: ... ' Declare necessary API routines: ... Declare Function FindWindow Lib "user32" Alias _ ... switch to the Excel sheet to see what happened. ...
    (microsoft.public.access.forms)
  • Re: VB6 works fine on XP but not Vista - Error 445
    ... The API isn't a single entity, it's actually a collection of libraries. ... Typically, the functions built into VB are enough to do the job, but they're fairly low-level, so if you're trying to do something like a recursive search, you'd have to write the code yourself. ... my program searches a selectable drive and finds certain excel files. ... It then opens each file serparately in Excel and extracts info from each based on certain criteria. ...
    (microsoft.public.vb.general.discussion)
  • RE: Cannot get code to work for API Save Dialog Box
    ... 'Set filter to show only Excel spreadsheets ... With xlSheet ... Dim Hwnd As Long ... ' If Excel is running this API call returns its handle. ...
    (microsoft.public.access.forms)