download

  1. 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...
  2. 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...
  3. 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...
  4. 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
  5. 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!
  6. 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 =...
  7. 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...
  8. 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...
  9. 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:
  10. 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...
  11. 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...
  12. 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...
  13. 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.
  14. 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...
  15. 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...
  16. 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...
  17. 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
  18. 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...
  19. S

    changing from every row to static

    I'd like to change the following code so that instead of going every row, it will allow the button on that row to run the code for just that row (if this makes sense). Basically I have two macros- one that checks every row (in a certain column) for data and if something is there, makes a button...
  20. S

    Failing to Find File

    So my code was working perfectly last week (when it ran for the first time. Now it says it can't find the "temp" folder that it created....and I see the folder on teh desktop. It's bugging out at the "Kill (TempFolderOLD) line. Ideas? Sub Downloadx()Dim URL As String Dim tstamp As String Dim...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top