api

  1. A

    Need Help to retrieve an API result in Worksheet

    Hello, I am designing an excel file which will provide me the company website URL taking the Company name as Input. For this I have found out a free API which does this exact Name->Domain mapping. The API goes like this: https://autocomplete.clearbit.com/v1/companies/suggest?query=[C_NAME]...
  2. Jaafar Tribak

    Workbook BeforeClose Cancel button

    Hi dear members, Let's assume there is a workbook project where an API timer (SetTimer) is started in the workbook open event... This timer is supposed to be running thoughout the life of the workbook until it is closed. In the workbook before_close event, the timer is cancelled by calling the...
  3. N

    Extract Data Through API

    Hi, I want to extract data of a particular Website through its API but i am unable to do so. Is it possible ? If yes please help me out.
  4. J

    MSXML2.XMLHTTP not refreshing or updating

    Hello, I have a query that connect to a API to update a set of data. The problem I am having is once the date first loads any further updates do not update. It is like the connections has been cache or something. Is there a way I can clear the cache so it will update every time it is run. A...
  5. L

    Can u Explain Powerbi rest api AddRows?

    Hi, I am taking a shot at a real-time dashboard, I'd get a kick out of the chance to utilize the powerbi Rest API. My inquiry how does the refreshing of columns function. I have 1300 records to stack once and after that refresh 2 sections for each column at regular intervals. The main rest...
  6. D

    Any way to tell Excel to disregard all other calculation processes EXCEPT a certain one (or at least give priority to the newest one)?

    My file uses an API to pull in 500+ streaming stock-quotes -- once the connection has been established and they're being pulled in, they update rather quickly BUT the initial API call to the stock data provider's service often takes over a minute...I suspect it's because I've got a bunch of...
  7. S

    Real time (or near time) security statistics

    I have a keen interest now in analyzing stocks and other forms of securities. I would like to be able to have Excel grab the information automatically and keep it up to date, but have been unsuccessful thus far. I understand this used to be possible from Yahoo Finance, but apparently they no...
  8. P

    Marketo Connection Power Query Expression.Error: The field 'access_token' of the record wasn't found

    Hello All, I am trying to connect my Marketo data to Excel. I have a custom service, client secret, and client ID. I set an anonymous credential setting because I did not know what else to select. Other options (Windows, Basic, Web API, Org Account) but those all asked for things out side of...
  9. Q

    API Data Source Error

    I'm pulling data every minute from the web via api however occasionally a window pops up with an error message "DataSource.Error: Web.Contents failed to get contents" and everything stops. Once I hit the OK button on that window everything works fine again. I realize that occasionally I will...
  10. S

    Advanced JSON Data Query with Web API (URL parts?)

    Hello, I'm using a Web API to retrieve tables of JSON data successfully into my spreadsheet. In the Query Editor window, there's an "applied steps" sequential list, featuring the first step, "source". Source is the actual web URL of the API itself. The dialog box for source allows entry of the...
  11. M

    Alpha Advantage API

    Has anyone used Alpha Advantage APIs with excel for importing live stock prices? Yahpoo seem to have dumped their API with no notice and saw this mentioned in a thread as an alternative.
  12. S

    Yahoo Finance api change?

    I use the yahoo financial api to download mutual fund prices each day. It has worked fine for months. Today I got run time error 1004 application defined or object defined error the apparent cause of the error is highlighted in bold below. { code Set DataSheet = ActiveSheet...
  13. P

    Extract data from Summit FT

    Is there a way for excel to extract data from Summit FT system through some API or some VBA code?
  14. P

    Pull specific data from API feed

    Hi, I am trying to build a formula that uses some data pulled in from a webservice api. This is the forumual =WEBSERVICE("https://api.coinmarketcap.com/v1/ticker/ethereum/") What i want to do is populate a cell with the current price in USD which is displayed as "price_usd";"343.114" I have...
  15. K

    Retrieve Data to Excel file from other software

    Dear All, I got a question on the Excel VBA with other software running in my PC. I created a excel file and used DDE to connect the data from the trading software (SPTrader) is fine. Now I want to retrieve the traded record back to the excel file for other purpose. Then I used WinAPI...
  16. C

    Shape JSON Data from web API

    I am struggling to extract the data from my JSON source (see below) [{"id":"TEST1","created_at":"2017-02-22 11:55:15 +0000","updated_at":"2017-02-22 12:09:56 +0000","created_by":"chris.k@b.com","fields":[{"id<wbr style="color: rgb(0, 0, 0); font-family: Consolas, "Courier New", monospace...
  17. V

    Vba api

    <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;"> I don't know much about API, in fact, almost nothing. I...
  18. L

    VBA Code to move windows via call to API

    Good afternoon, Can anyone provide me with the code required to find the screen co-ordinates of any window, searchable by its window name as it would appear in appActivate() for example? I know nothing about using APIs to find windows, nor handles etc., and the numerous threads I have read...
  19. C

    Automating Print dialog for AcroPDF to XPS API

    Hello all, I'm currently working on a system to print down specific pages from a PDF file loaded into a webbrowser control on a userform into the XPS document writer. I've managed to cahnge the default printer, reference the pdf, run the printpages function and (sometimes) automate the...
  20. D

    Help getting started with using Excel VBA to get info from API

    Hello all, I have been using the site BrickLink for the past year and would like to use their API to get information from their catalog, etc. I have some basic VBA knowledge, but I am stumped when it comes to using it for this task. I think I have a good grasp of how to use the various methods...

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