download

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...

With a little help, I've written some code. The intention of this is to perform weekly updates of a downloadable file. This macro, if it works, will be copied over and over (unless someone has a better way, PLEASE!) so that roughly 25 different files can be downloaded individually and/or...

I realize that there are more efficient ways to obtain files from websites using VBA but I really want to figure out how to control the Dialogue Box that pops up when a user is trying to download a file. To be more specific, I want to select "Save As" and set the file destination. The...

So I have a wonderful piece of code that someone helped me put together. It downloads a file from a website (just a pdf from a cell-specified URL) and then time stamps it (so you can quickly download again for updates). It references cell A1 for the URL... and I have 5 pieces that download...

I have a macro that runs/calls 10 other macros that download pdfs from specified URLs online. these aren't big files... like 5-8mb BUT these are coming via a VERY SLOW satellite link... so if I download 10 pdfs via 11 macros (1 macro that calls each of the 10), is there a way/a macro/piece of...

All - I've checked previous threads on this topic and havent found what I'm looking for. In my VBA I am downloading data from the first sheet on a Google Sheet workbook. This has not been a problem. I am using this code... ' Download Production Schedule as csv...

I manage a team spreadsheet and there's a hyperlink to open a subfolder. It works fine on my computer and others next to me. My supervisor's computer though will not open the hyperlinked folder and gets the error message Unable to open ... Cannot download the information you requested. Why does...

I need download data from sport webpaes which runs upto 150 matches or so, depending on no of teams participate in the tournament and each match will have two pages. for eg: to download data for match between baroda vs mumbai , gujarat vs maharashtra, mp vs...

Hi everyone. I have a document that I have links which open up a PDF and I would like a macro to go through and download all of these documents into a file path. Is this possible? Thank you for your help. I have this vba as of now which downloads the pdf but nothing appears in the PDF I think...

Experts, I'm in the process of writing a couple of VBA scripts that will enable the user to download an Excel file from our password protected SharePoint site and import the data into the active workbook. I work for a government office, and our SharePoint site required a CAC login (CAC card...

Here is VBA code which automates the complete 'Save As' file download procedure in IE11, when a download is offered by IE's Download Notification Bar. To use for your own web site downloads you would automate IE and do whatever is necessary to make the Download Notification Bar appear at the...

I have VBA code which retrieves historical stock prices data for the last number of periods (days, weeks or months) up to the endDate specified by the user in the workbook. If I try to download data for more than 100 shares at a time, the speed of download progressively decreases. The only...

Hi all, My objective is to automate the download the current futures data from the website www.nseindia.com. For this, I tried using the following code: Sub Test1() Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.Navigate...

Hello, I have some images in column "E:E" for each cell and I need to download them and save with the number of the material in the column "B:B". The images do not follow the correct sequence, beginning in 1 to n, so, first of all, we need to select the image and then save it in desktop. For...

Hello, I am trying to download a csv to an existingspreadsheet, I have the following, I have tried NewWindow true and false makesno difference, always opens a new workbook. How do I make it download to a specific sheet in the openworkbook...

Hello, I am trying to alter some code to download a reportas a csv instead of XML due to the size. The following code works as XML Reports/Operations/sales/MI/hier full&rs:format=xml I assumed I would just need to change the format=xml toformat=csv However I get an error stating “whitespace is...

Is there a way to change the colour of Excel/Word icons on the ribbon and quick access bars? Or a download?

I am using the FAME (facebook ads manager for excel) add-on which downloads ad data from the api. It's pretty neat but I've noticed it won't download data unless excel is my active window. This means I have to sit and stare at my screen doing nothing else for the time it takes to download. Do...

Hi, I want to download the data in excel from the below link and save it in Birt folder“C:\Users\E5554593\Desktop\A5554593\Birt report” Url: http://147.249.55.189/birt-viewer/frameset?__report=BPO/realtime_sla_role.rptdesign Above URL give multiple options in that it should Click on “BPO_DVW”...

I need help Automating passed the Frame Notification Bar or Open, Save, Save as, Save and open, Cancel Dialog Box that shows up when you Click a Button to download a file using VBA and IE11. After going through the initial Login page, I navigate to the Download page. The download page has 4...