api

  1. I

    API, VBA or whatever is best

    Greetings, I am looking for some excel help with connecting, filtering and using a website API. I have an example of what I am doing by hand and I am looking to automate the process as much as I can. Right now I have a row with airport codes along the top, I then have a row going down...
  2. A

    WinHttpRequest as a function (us census API)

    Hi All, I have made a Sub that I would like to turn into a function, but am having issues getting it to work. here is the Sub I got to work and the function I am trying to get to work Public Sub Runapi() Dim W As Worksheet: Set W = ActiveSheet Dim URL As String: URL =...
  3. B

    New to APIs Question

    I've been searching the boards, but still can't seem to find an answer to why this doesn't work. The authentication works, but when I then try to query the part number I get - "<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN"><HTML> <HEAD> <TITLE>Error 500--Internal Server Error</TITLE>...
  4. L

    VBA and Amazon API Integration

    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...
  5. W

    Using XMLHTTP to upload a file to API

    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...
  6. D

    Handler for image object in GetPixel() API - function?

    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...
  7. N

    Use VBA to shorten URLs with Goog.le?

    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...
  8. O

    SOAP, REST API and password protect macro

    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
  9. S

    Looking for an Excel Guru to do some data manipulation understanding lego is a plus

    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>
  10. B

    Report builder refreshing error - excel auto protection workbook issue

    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...
  11. A

    VBA for calling back a webtable

    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...
  12. DaniExcel

    Excellent Analytics.

    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...
  13. G

    Using a table to generate multiple lines of data

    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...
  14. K

    Excel VBA API Interaction - Domai

    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...
  15. B

    VBA API Guidance

    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...
  16. D

    Query Google analytics data via there API

    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...
  17. S

    Use Excel to Generate InfoPath Surveys

    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...
  18. T

    InternetExplorer Object from Hwnd...

    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...
  19. G

    Open Excel at Specific Time

    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...
  20. B

    Challenge: Calling a Web Service (API) Through Excel 2010 VBA

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top