Vba download intranet file

Asked 8 years, 4 months ago. Active 10 months ago. 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? Users supply information and then make the calls.

We were unable to develop in house with ftp. Hope this helps other looking for info! Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site the association bonus does not count. Those cases require a different approach. Check, for example, this code for logging. I need to download recordings from my dialer, will it work if so what I need except Microsoft Excel on my system.

Sorry to ask a very basic question. As long as you are using Windows, then Excel is the only software that you will need. Just download the sample files, add your URLs, specify the download folder and click the download button. Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page. Share this. Share 0. Tweet 0. Article Navigation Heading 2 Example. Heading 2 Example. Category: Freeware Tools. Christos Samaras. 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. Im using : 'wait until the page loads Do While ie.

Busy Or ie. Any other ideas as to how to make IE wait until the page is completely ready? I wondered about possibly checking the. Thanks, Scott. Hey guys, I'm trying to write a macro which prints to PDF and saves the file name as the contents of a cell.

I've been looking through all the posts currently on this forum to get something working. Range 'Z1'. I want the macro to automatically name the file with the contents of cell Z1. I then want it to then automatically press enter. Any ideas where I'm going wrong? Any help would be much appreciated! I have an excel file sitting in a shared network folder. I only want one user to be able to make changes at a time any other users would get a read-only.

For some reason it currently does not do this, and I have multiple users with the same doc open. I'm concerned that changes will get over-written when 2 people are saving their changes. Can anyone help me with the settings for this. I have a file that became too big due to phantom bloat, unused range saved by Excel and all that kind of reasons.

Thank to previous posts on that board tackling that issue, I was able to find how to proceed to reduce the file back to its normal size. But I did so in a beta file test file. The real file has become so big MB! The file contains archive info that we do not have anywhere else. Is there anyway then to open the file or to reduce its size without opening it through magics I just honestly don't know how to retrieve that info before deleting that file.