download files

  1. R

    downloading completed?

    My programme causes a specific site to download a csv workbook. (It does this by sending keystrokes, and strings). It works perfectly well, but I then want to analyse the sheets. Now I cannot do this until I know the download has completed; but it will not complete while excel is running. So...
  2. M

    Downloading a data from a web page and pasting it on an excel Sheet

    <colgroup><col></colgroup><tbody> <tbody> I am brand new to the world of macros and visual basic, so bear with me . I want to create a macro that will automatically pull data from the web by simply pressing a macro button. I assume that this would be an easy task if the data is from a website...
  3. P

    Download files from URL

    <article>Hello All, I have a list of URLs that each one opens a webpage were an undetermined number of files (.pdf) are stored, I cannot anticipate the names of the files. I need a macro to go through each of those pages and automatically download all the files present there, save them in a...
  4. savindrasingh

    File downloader VBA to VBS

    Hello Experts, I have below code to download some files from given URLs using VBA. Is there a way using which I can use this function in VB Script? Currently it is not allowing me to use these functions as is: Private Declare Function URLDownloadToFileA Lib "urlmon" (ByVal pCaller As Long, _...
  5. E

    Internet explorer download automation

    Hello, Im trying to download this example file, everything in the code works, except that I can't find out how to press the save or save as button when the dialog box in InternetExplorer appears. I've tried displayalerts, sendkeys and I had no success. Its really frustrating. Thanks for the...
  6. M

    Download file from Excel

    hi, I would like seek some help on how to download html / pdf files using excel. It could be formula or a macro. Response is highly appreciated.

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top