Vba to download file

The folder will open into a windows explorer. Copy the path. Use this Path into Code [SharepointAddress]. Along with this, do not forget to add the site address to your trusted sites in the internet explorer security settings.

Step — 1 Login to sharepoint site from Internet Explorer. Now, use the below mentioned code and call the sub DownloadListFromSharepoint. Viewed k times. Improve this question. Add a comment. Active Oldest Votes. Stream" oStream. Open oStream. Write WinHttpReq. Close End If End Sub. Improve this answer.

Rafiki 5 5 silver badges 15 15 bronze badges. Thanks--very cool. My only issue is that then anybody who gets to the VBA of your file has your password. Any tips for getting around that or encrypting it in some way? Thanks again! No problem : You are correct, it's not good practice to store passwords in your code.

In excel you can encrypt files so that users can't se your code. However, apart from the file names, the user should also define and the file extensions ; for example, Test. The user then will have to add the extensions manually. The zip file contains both workbook versions the old and the updated ones. The files can be opened with Excel or newer. Please enable macros before using them. Page last modified: September 28, I founded this site back in intending to provide solutions to various engineering and programming problems.

I do have a question though, is this file suitable to download a shared file from SharePoint? If you want to download from SharePoint, you have to be logged-in first. However, this cannot be done with the VBA code shown here. Hi Christos! Great job with this file! Any other solution?

Thank you for pointing out the issue. It seems that for some unknown reason, Google accidentally marked the file as a virus! I have updated the link, so now you will be able to download both files.

But again, the second I save as. Does anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to 'stick' so that they don't revert back to scientific format when I reopen the file? Thanks so much for your help! I'm having a problem in a workbook with several ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color.

So I removed the form control buttons and created new ActiveX command buttons. I got into the button properties and set the background colors. All of the buttons were working fine. Then I saved and closed the workbook and went to lunch. Now when I open the workbook, the buttons don't work!

When I click them nothing happens. They appear frozen. They don't even seem to click. No error message. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties.

I can't seem to locate the command button properties any longer. The odd thing is if I create a new button it works fine until I save and close the file. When I reopen the file none of the buttons work. It's like the buttons are being disabled when I close or open the file. Any suggestions? Is it possible to import a single text file into Excel, splitting the incoming data across multiple worksheets rather than a single worksheet?

Each each row on the text file would be evaluated by the value in one of it's 'columns' and written to the appropriate worksheet. The file is '! The files are very large, sometimes exceeding the 65, row limit, which I could avoid if the data was split out coming in.

Thanks abe. The File Is Locked. Hi all, I've been getting this error on occasion recently. Is there a way, perhaps through VBA, that I can not allow a user to save while somebody else is opening the document? Other suggestions on how to avoid this error? I have workbook in which I want to save a specific worksheet to a new file with only the values saved - all data in this worksheet are references to cells on another worksheet, which is using VLOOKUP to pull data from a database.

Found the following code and it gets me close, but it copies the cell references, not the values. It also allows me to specify the file name from a cell reference. I want the new workbook file to simply be saved, not opened, and a message box to display stating where the file was saved will always be in the same location on the LAN.

What modifications do I make to this to get this to work per above requirements? Range 'B2'. Text Sheets 'Sheet3'. Copy ActiveWorkbook. Workbook A has a cell that gets data from workbook B as an external link.

It does this using the indirect function because it needs to concatenate the path and filename from other cells. So can indirect work using closed external files or must the external files be opened?

Is there a clever way of making that work? Do While Ie. I automating a task at work that will save some time. Seems simple enough but for some reason the code I have to cause IE to wait unil ready doesnt seem to work in all cases.