VBA download excel file from website with authentication

Beginners will have trouble cracking it. As for the code itself, it has to be done stepwise. What is the first page control to be filled or clicked?

Right click it, choose inspect to get DOM information as exemplified below and paste the picture here so we can start building the macro. This will be a bit difficult to do without actual access to the page for testing purposes. You must log in or register to reply here. Similar threads E. Ericng Apr 26, Excel Questions. Replies 0 Views Apr 26, Ericng. Question Downloading an xls from a website after authenticating via MS Edge. Sep 22, excelos. Question How to connect a table to external data from website that requires login credentials?

Dec 15, parankush. 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.

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. Eileen's Lounge Skip to content. Quick links. Hide Exit Sub End Sub. It works and downloaded but I think it's corrupted.

I can't open that file. Do you have any idea about that. Additional info: Original file size 34kb. Downloaded file size 29kb. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Introducing Content Health, a new way to keep the knowledge base up-to-date. Podcast what if you could invest in your favorite developer? Featured on Meta. Now live: A fully responsive profile.