api

Can someone point me in the right direction to make this work? GetLowestPricedOffersForASIN I have all the keys i need and i'm trying to to use XMLHTTP60 lib to open the address http://mws.amazonservices.com?&ASIN=B00COK3FD8... etc but its not working. Would anyone know what im doing wrong. I...

I am developing a tool to assist my sales team in the quotation process. Majority of our quotation is done in Excel, as part of when the quote is generated it saves the quote as a PDF and I would like it to automatically upload all the quote data and a copy of the PDF to our CRM package using...

Hi, I have searched but got stuck on correctly declaring and using the API function getpixel() in vba, hence i making a thread on this subject. I'm aware relevant post exist, but i failed to implement their solution. What I would like to do: get the color of certain pixel of an image pasted...

I need to shorten many many many URLs using Goog.le. So, I have sound this site that walks through it http://www.jpsoftwaretech.com/google-url-shortener-api/ but I can't seem to make it work. It is printing results, but not getting any shortened URLs. I know he uses a custom MSXML Object...

Hi, I'm gonna try to pull data into MsExcel using an API. I have the choice between REST or SOAP, what's best? Any code example somewhere? Although, to call the API I will need to provide my password in clear. Is there a way to protect (password?) the part of the code running the API? Thank you

Hello Guru's I am in need of a Excel GURU that understands lego ...yep those little tiny bricks. If you also understand API that is a plus as thats the next step I need. I have found the people on this site are STELLAR!! Who is up for it>

Hello, It seems my Adobe Report Builder v.5.0.4 doesn't refresh any reports anymore in Excel v.14. I see 2 errors, I think one due to the other: 1) If I hit the refresh all button in the Add-in tab or in the Request Manager all my tabs in the workbook jump to protected view. 2) If I refresh a...

Hi I am rather new to this and have written a VBA by following some directions to call back a specific table data from a webpage, but I would like to be able to do this for multiple rows at a time not just one. can any one help. Here is what I have so far My sheet is setup to have a EIN column...

Hi, I hope this is not too obscure for this forum as it actually relates a little more to GA than Excel. Apologies if I am asking in the wrong space. I have recently started using the Excellent Analytics plug in for GA in order to work with my data in Excel. I have found my way around using it...

I have an excel workbook, that has a table that I need to use. The current way that I have to use it is by manually entering in each line of data one by one to generate the correct number. I was wondering if there is any formula to have the table pull from each line and generate the answer in a...

Howdy, I have been assigned to create a macro which will check available domains via a website called domai.nr They do have a API as well available at: https://www.mashape.com/nbio/domainr#!documentation I was able to get the availability of the domain by using a code to open the site and use...

So I've been searching on the site for the last 20-30 minutes, and I think I'm just not looking for the right value....so I need some help. What I'm wanting to know is....can VBA rewrite an API URL based on certain values selected in either text box, drop down, or even check marks? My API URL...

I want to be able to query data from Google Analytics API into excel using VBA. I have tried Googling the web and this forum but all I can find is partial codes or Excel add-ins like "Automate analytics" which do not work for me because I want to query the data and then further write the macro...

Hello, I can’t seem to find any threads/materials online to help with the following Excel VBA automation problem and I am looking for some help/direction – I am currently developing a corrective action tracker in Excel that generates a new Microsoft InfoPath survey for each corrective action...

Hi All, I'm aware a number of people have asked this around the internet, and that the accepted solution in general uses the SHDocVw.ShellWindows collection. However, this doesn't work properly for me ("Out of memory error" when constructing the class, probably I'm working on a VM which doesn't...

I created a macro that runs at a specific time of day a few weeks ago but it will only run if the excel program is open. Is there any way that if excel is not already running that I can have it open automatically a few minutes before my macro should run. I'm thinking it will have something to...

Hello all - I'm working on an research project where we want to analyze the sentiment of a large number of small blocks of text. And, yes, I'm all too familiar with the pitfalls of automated sentiment analysis. Setting that aside, I'd like to test out the effectiveness of different APIs on...

Hi, On VBA form I am using two listview controls(Listview version 6.0 from MSCOMCTL.OCX). I want to bind both listviews scrollbar together, so if I scroll one list view, other should scroll too. I think that is not possible with native VBA.But.. This could be done through using win32 API...

Hi, I'm trying to use Zoho CRM's API to suck data directly into Excel using a web query. The data comes in XML format. When I pull the data into Excel, it comes like this: uri no FL val /crm/private/xml/Leads/getCVRecords 1 *the actual...

First off, does anyone know in which Bloomberg Addin is the BDH formula found? Secondly, if possible, I've had a hunt on the internet to no avail, but does anyone know the passwords to the addins? The first point is the most important, the second is just a bonus :) thanks in advance.