download

  1. S

    QueryTables bug. If one query fails, all subsequent queries will fail unless restart Excel

    I wrote a VBA code to download stock data from Yahoo Finance. To explain the bug that I discovered, I wrote the following VBA program. The VBA program downloads data for stock symbols SPY, XXX, and QQQ from the Yahoo Finance website and displays the downloaded data on sheet 1. Because the stock...
  2. H

    Macro to download zip, unpack and copy data

    Hello All, I found a macro from @ZVI which I think should do what I need, download a file from a page, open the zip file, copy the contents of the CSV and paste it into a tab in the file that also contains the macro. After inserting the link it always says file not found. Since the link keeps...
  3. most

    Handling errors from a WinHttpReq function

    Hi, I would like some assistance with handling errors from this function. SomeDownload1 will return WinHttpReq.Status = 404, what is the best practice of returning a error code back to sub routine? SomeDownload2 will run-time error at line 6 (WinHttpReq.send), how to handle this? I searched...
  4. M

    Using the Macscript function to download and rename a file.

    I couldn't get this sub to work so I've made some changes to it but I no longer have access to a MAC to test on. Can someone test this for me or tell me a way of downloading and renaming a file and then specifying its path while on MAC...
  5. M

    How to download a ZIP file and access its contents while on MAC.

    I'm aware that I can use activedocument.follow hyperlink to download a file given a URL, but I'm unsure of how to interact with that file after it has been downloaded. Is it possible to rename the file upon download or specify where the file is downloaded to using VBA? Furthermore, how can I go...
  6. P

    How to click on download button tableau dashboard webpage using excel vba

    I'm trying to click on button using element by classname tag name but no success
  7. M

    How to open up internet explorer and download file

    Hi, I have a file which can be accessed through internet explorer. Do you know how to write a macro to download the file through excel? I'm imagining maybe shell command might work. Thanks!
  8. K

    Web Scrapping - Download PDF after submitting Policy

    I want to download the PDF file after pressing "Continue" with below code... ================================Code========================= Sub automaticformfilling() Dim ie As Object Set ie = CreateObject("internetexplorer.application") '1 GoTo website With ie .Visible =...
  9. K

    Extract email messages from outlook to excel with attachment(s) information

    Dear All, I have this vba which will extract the outlook messages to excel however I am not sure how can extract the attachment information along with this. Requesting your help please Sub GetFromOutlook() Dim OutlookApp As Outlook.Application Dim OutlookNamespace As Namespace Dim Folder As...
  10. B

    Download WAV file from URL link

    Hello, I have a list of URL links in excel and each link goes to a breif WAV file recording. In fact, when you click on the link the option pops up to either open or download. Is there a way to through VBA, MACRO, or other automated means to run through this list of over 40,000 and download...
  11. S

    VBA to download images and rename

    Hi i have an excel file with links to images in column L i need to download them and rename them with the list in column M Thanks !:):nya:
  12. P

    Power Query - Remove duplicates from Folder Download

    Hi, I'm creating a personal account analysis system and using the 'From File, From Folder' process in Power Query. The issue I'm having is to identify where two downloads from a bank or credit card account cover the same period and hence have duplicate entries. In doing so I want to avoid...
  13. E

    Macro to automatically download file

    I really need help in finding a macro to download a pdf file online, e.g. www.example.com/JUN%25%25JUN19.pdf. The link of the download URL will change everyday based on the date. I will be saving it into a drive C://Downloads. Also, is there any way to also automatically convert the pdf file...
  14. J

    Download over 1 million rows from data.cms.gov

    I am trying to download data from data.cms.gov the file contains more than 1.2 million rows, used power query download web option but get error message all the time. Below is the link, I am using excel 2013. Can someone help me...
  15. R

    HTML/PHP that can generate excel file for download

    Hello, Anyone who knows if it is possible to set up a webpage (HTML/PHP?) with some fields to fill and then generate excel file that you can download with those data from webpage? Have been searching for this subject for a while now, but can't really find any related.
  16. L

    Missing the Green Arrow, top left corner to change text to number

    So this one is weird. We download into excel from a website and my co-worker doesn't have the green arrow in the top corner to be able to change the text to numbers. If she sends me the spreadsheet, or I download it myself, I can do it, but it never comes up on her machine, so she can't do...
  17. D

    automating query in VBA

    not sure if this can be done, but every day I download data via an Excel add-in ("transfer data from iseries") which I beleive is a way to download data from AS400. Every day, I need to click the Excel add-in, enter my user name and password (which is painful) then i tell the admin to start the...
  18. B

    Can i use a ribbon editor within excel with out having to get other users to download the editor program

    I am recently self taught on using a ribbon editor to set up some ribbon on my excel program that other people use on different computers (not linked in any way) and all is working well, however i was wondering if it is possible to have the codes in my ribbon editor somehow included in my excel...
  19. K

    Publish interactive excel file online, locked cells and disable download

    Hi, How can I have a working spreadsheet online that a 3rd party can enter values into unlocked cells, but not be able to download a copy of the file? It looks like Excel Online always has a 'Save as' or 'Download a copy' option. Is there a way to publish it on a web page that works? Thanks
  20. S

    Downloading code bogging excel

    I have some code that downloads pdf sheets at hte push of a button. The code works like a champ but (I presume because my internet connection is beyond super slow (satellite, 0.34mbps download....), excel goes into a "not responding" mode until the download completes. Is there any way to fix...

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