api

  1. S

    Copy and paste excell cell data to another software with sendkeys or API

    Hello, I have to take data from an excel file that contains mostly int or float that correspond to electrical engineering simulations and paste them into a software that is called Cymcap to run these simulations. Each line of the excel file is a simulation and sometimes there are hundreds of...
  2. N

    Can't obtain url string after redirect

    My goal is to obtain information from a url via the API, return the data as JSON, parsing it and then returning it to Excel range. The problem I’m facing arises when the 1st url gets redirected automatically. I have tried to implement a wait in the code, to wait till the 1st url is redirected...
  3. S

    Can the border properties of a UserForm be changed through Windows API calls..?

    I recently started using Excel 2019 on Windows 10. In this environment, Windows places a thin red border around VBA UserForms, and there are no properties within VBA to change it. In the screenshot below, I've changed the UserForm border style to 'Thin' & color to 'Black' to show what I mean...
  4. T

    PowerQuery Error after reopening workbook "Authorization Error: The credentials for the source Web invalid."

    Hi All, I'd like to get the spotify web api data from the following link thru Excel PowerQuery web connector: Spotify API link I created a web query with the following code: let Bron = Json.Document(Web.Contents(functionGetNamedRange("SourceURL"), [Headers=[Accept="application/json"...
  5. Y

    VBA to pass GET to API

    Hello, I know this question has been asked before, but I still find myself lost. In short, I would like help with creating VBA code that passes the following GET request to an API, and returns the JSON results in 'Sheet2'...
  6. C

    Need help with JSON in Power Query

    Hello all, Please forgive me if my post does not sound very professiona as I am quite proficient in Power Query when I extract data from local sources, but this time I have faced a REST API and got a bit lost. I have connected through a REST API and receive data in JSON format. Surprisingly...
  7. smozgur

    Translate to Multiple Languages with Power Query - Part 3

    In the previous article of this series, Power Query vs. Google Translation API - Part 2, we discussed how to make more effective Google Translation API calls by combining all rows as a whole text with a delimiter and send it to the web server in a single batch. In this last article of the...
  8. smozgur

    Power Query vs. Google Translation API - Part 2

    In the first article of this series, Using Power Query in Excel to Translate Data Using the Google Translation API, we discussed retrieving data from a web server by using a simple API call. In the article, we used the Google Translation API endpoint. Although it seems like a good idea to...
  9. smozgur

    Using Power Query in Excel to Translate Data Using the Google Translation API

    When I started reading Jeffrey McManus' Database Access with Visual Basic book decades ago, I was very much aware that data was everything. I kept saying "You have a project only if you have a data set to manage". However, back in those days, you were mostly limited with the data included in the...
  10. A

    Will a kind soul help to provide a vba solution to press a button (e.g 3) in Microsoft calculator without using sendkeys?

    Hi all, Will a kind soul help to provide a vba solution to press a button (e.g 3) in Microsoft calculator without using sendkeys?
  11. M

    How do I pass the body for a POST HTTP request using YouTube API playlistitems.insert?

    I keep getting the wrong number of arguments or invalid property assignment error but I'm not sure what I'm doing wrong now. Here are some pictures:
  12. C

    Show worksheet range of cells in a user form

    I would like some help finishing the VBA code that I'm trying to piece together. I have 2 ranges of cells in a worksheet ("Data") that I would like to show individually (not at the same time) on a user form while working on another worksheet ("Input") within the same workbook. The user form...
  13. M

    Need a macro to completely stop running, then start again on its own.

    Knowledge of how to use the Bloomberg terminal is not required to solve this problem, but if you do know how to control Bloomberg with Excel then feel free to tell me if there is a completely better way to accomplish my goals. I have a list of about 20 tickers from B19 to B40 (the list has a...
  14. C

    Userform to display in task bar

    I know i am kind of beating a dead horse around the internet with this, but i used to be operating on windows 7 and my code functioned for showing a taskbar icon for the userform when the application window was hidden, but when i upgraded to windows 10, the code stopped working. is there...
  15. H

    PDF Manipulation in VBA

    This my be outside the scope of this messageboard. I have a number of automation processes running many reports and such. One of the tasks that needs to be done is to save an word file as a PDF. This is, of course, trivial in VBA. However... What I really need to do is use Acrobat DC ability...
  16. mole999

    Overpass API

    Anyone with experience using APIs or this one specifically. I have 92K locations stored with Easting / Northing. The API suggests that it has Road Speed for a large proportion of the road network (UK) and I'd like to use a formula or script to import this data against known location data. I can...
  17. C

    Find cell values >0 and return column header label

    Hi, I'm looking for help in creating a formula that can return column header names if the value in the cell is greater than 0. If Id 1 has a cell values >0, I want tag (header 2) and API (header 3) to be returned on a separate list. Example of data: Pixel(header1) Tag...
  18. L

    VBA - How to get the serial number of UNC Drive Without API calling

    Guys For security reasons I want that my workbook can only be used if it is on a network. This network sometimes is mapped by user with different Letters. I would like to find a way to get the serial number of the network drive based on the UNC path instead of Drive Letter. But I would like to...
  19. K

    Change the line spacing between items in a VBA listbox

    Hi Guys, I'd like to change the line spacing between items in a VBA listbox. Let's assume I display month names in a listbox control. Name of my listbox is "Lista". It's easy, I just add one line to "Private Sub UserForm_Initialize" for the userform: Lista.List = Array("January", "February"...
  20. WarPigl3t

    Excel VBA buy and sell stock market API

    I am an expeienced VBA programmer. I have been researching like crazy to see if I can find an API that would support VBA. The only one I found doesnt exist anymore. I want to buy and sell stocks from the stock market automatically when I initiate a VBA macro and leave the house to let it do...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top