Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web services
Hi,
I've been searching around for info on web services using 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web services
On Oct 6, 10:21 am, Ed Peters wrote:
Hi, I've been searching around for info on web services using 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web services
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 Google Web APIs 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/...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 Point Services. If you can figure it all out, please let us know. :O Good luck. -- Dana DeLouis "Leith Ross" wrote in message ups.com... On Oct 6, 10:21 am, Ed Peters wrote: Hi, I've been searching around for info on web services using 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web services
On Oct 6, 11:40 pm, "Dana DeLouis" 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/...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" wrote in message ups.com... On Oct 6, 10:21 am, Ed Peters 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Text Services to Counts of Services | Excel Discussion (Misc queries) | |||
ACCOUNTING SERVICES | Excel Discussion (Misc queries) | |||
Excel, COM+ and Web Services | Excel Programming | |||
Web Services using vba | Excel Programming | |||
Web Services using vba | Excel Programming |