download file

Hi All, I am a complete novice but trying to do the following in 2 steps. I have a dashboard in an excel document that uses data from a .csv download from a site. There is a direct download URL that requires me to enter my username and password before it starts downloading. I then want the macro...

Hi All, I need some help regarding downloading a picture and then save it in a folder. Right now i have the following: Private Declare PtrSafe Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As...

Hello: I have the below macro which pulls in an excel file from the Bloomberg application. Microsoft excel does not stop processing the VBA. I need the macro to stop until the file named "grid*.xls" is opened, and then start again so I can copy and paste the data. Please advise - been stuck...

Hi all I need all of your valued help in creating a macro to download (.xlsm)files from sharepoint folder/sub-folder and save as it is in the given designated local drive folder. Below I have given the sharepoint scenario:- Sharepoint : Main Folder > Sub Folder1 > File1.xlsm >...

""This is my first post in this forum"" Would be great if some can help me on this.. ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Set objCollection = IE.Document.getElementsByTagName("a") For Each...

Program: EXCEL 2010 OS: Windows 8.1 I am wanting to login to a site (I have a login script), navigate to a page, then download the `.CSV` file that will always end with a dynamic string due to it being 'custom'. I have tried to access the site by recording a macro. However, as the...

Back in IE8, when you tried to download a file, it'd pop up a little box asking if you wanted to download or save the file. Macros in Excel could work through it using code like 'hWnd = FindWindow("#32770", "File Download")' to get the box and interact with it. IE11 now has an obnoxious little...

Hello! I have an excel file that has numerous download links (example below) in a column. Is there a way to 1. Open the link on an internet browser 2. Accept the download and then 3. Open the downloaded file? www.123contactform.com/upload_dld.php?fileid=0b5af5ff707e692b158427473985056e The...

Dim URL As StringDim LocalFileName As String Dim B As Boolean Dim ErrorText As String Dim C As Range Dim sTxt As String sTxt = Cells(1, "a").Value Dim Lastrow As Long Lastrow = Range("C:D").Find("*", , , , xlByRows, xlPrevious).Row For Each C In Range("C1:D" & Lastrow) If Len(C) > 0...