Importing Data From A Webpage With Password Protection
Jul 31, 2005
I am trying to import data from a website protected by ID and password. I do have the login ID and Password to login to the website.
I am importing data from the website to my excel sheet to track some shipping informations. I do have the 'Import to Excel' option but I would rather open the
spreadsheet and click Refresh Data and have all the Data imported with click of a button.
I have already tried to use Import External Data but it is not working.
have been trying to work out how to copy data from a website into a worksheet. For some reason the Data > Import External Data > New Web Query route does not work so I have tried the code below but cannot get this to work either.
What I am trying to achieve is to copy each of the various tables on the page into Excel.
Dim WebCopy As Object Dim WebtitleCopy As Object Set WebCopy = Sheets("Sheet2") WebCopy.Cells.Clear
I making a data entry form that sereval employees will be using. But what I need is data quality protection. My idea is to have a userform with a combo box. The employees would select there name from the combo box and then enter there personal password to get access to the data entry information, which will appear if the password is correct but kept hidden if password is incorrect. I have a example.xls without any code contain in it.
When opening a new Excel file, it is asking me for a password to an old excel file that was password protected, which I have deleted from my computer. It is still asking for this password every time I open a new or existing file. When I hit cancel it lets me open the file.
I've been playing around with the API functions (specifically, InternetOpenURL) to retrieve the contents of an HTTP webpage and store the information within a text file, using Excel VBA. It works great for any "normal" webpage not requiring a "Username" and "Password" login. I can't find any examples on how this is done for a webpage requiring such a login? I've heard you can do this via sending the appropriate cookie to the server, but I can't find any documentation on the web? Does anyone have any idea on how this functionality is achieved?
I use the following piece of code to show/hide certain worksheets in a workbook. To access the hidden sheets, a command button runs the code. It works very well, except that the password is openly displayed in the message box (as opposed to returning asterisks for the typed characters).
Sub togglesheets() Dim Ws As Worksheet Dim strPassword As String strPassword = InputBox("Enter Password") If strPassword "Password" Then MsgBox "Wrong Password": Exit Sub Application.ScreenUpdating = False For Each Ws In ActiveWorkbook.Worksheets If Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVisible Then Ws.Visible = xlSheetVeryHidden
ElseIf Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVeryHidden Then Ws.Visible = xlSheetVisible End If..............
I have tried Tools/Options/Security Password to modify, but it can still be saved as a copy to the network which becomes very confusing to many. If I use Tools/Potect Sheet, I need to re-enter the password for all sheets twice. I am trying have it so that everyone is read only, select people can edit (with same password). Password protect all sheets and the workbook with the same password everytime when the workbook is closed
Basically 2 questions
1) Is there a way of remembering a password so that when the workbook is closed it and all sheets are automatically protected with the same password every time
2) Is it possible to have it not copied unless it is opened by an editor
I have a macro that needs to unprotect the sheet before it does what it needs to do. The sheet has a password (i.e. it is not just protected). the macro runs fine but when I go back to the sheet and try to unprotect it, no password is required. simply clicking on Unprotect works and I am nopt prompted for the password in the macro.
I realise that they are not the most secure things anyway but the people who are going to using this will mess around enough to try and unprotect the sheet but if they were to be promted for the password they would stop looking.
I have a spreadsheet that was given to me, which I used as a template. It already had password protection in it for each worksheet, and the macros are also written to unprotect before performing the actions, the re-protect at the end. Everything works fine except I cannot change the password. The thing is is that the password in the macro code is not the same as the actual password which you have to type in when unprotecting the worksheets.
For example the password in the code is "IPP" and the password you have to actually enter into the unprotect sheet box is "AAAABBBABBB&", yet all the macros still work like this. When I attempt to unprotect the sheet (with the AAAA... code) and re-write the password codes in the macros to say "###" then re-protect the sheet with the new password and run the macros it'll work fine, but when I save and close and then re-open the password required to unprotect the sheet reverts back to the "AAAABBB...." and then the macros stop working because the passwords don't match (even though they didn't match before!!!)
There is no encryption password or workbook password as far as I can tell, only the worksheet protection. Why cannot I no get the password changed?
I have an auto_open module that runs a couple of other small sub routines, the query I have is it possible to hide the active window from a sub?
Because it does not seem to work for me, I can step through (F8) but when I open the workbook it just flikers but does not hide it's self.
I want to hide the work book as there is nothing that the users need to see, it just has VBA code to prcess data. There is a menu item created on the command bar so the user can run the code.
I have a pasword on the VBA code would this cause issues?
Sub Auto_Open() my_auto_open Add_Workbook_Menu_And_Items End Sub Sub my_auto_open() Dim w As Window For Each w In Workbooks("Star_Plus_Hindi_MKII.xls").Windows w.Visible = False Next End Sub
Is there a way users can be prompted for a password when a tab is clicked? if wrong or no password is entered, then show sheet 1 only. 1 main sheet, and 10 sub sheets. Any of the 10 tabs that get clicked need to be prompted for a password, each different.
I use the following piece of code to show/hide certain worksheets in a workbook. To access the hidden sheets, a command button runs the code. It works very well, except that the password is openly displayed in the message box (as opposed to returning asterisks for the typed characters). Is there a way of achieving this?
Sub togglesheets() 'This asks for a password before show / hide data sheets will work
Dim Ws As Worksheet Dim strPassword As String strPassword = InputBox("Enter Password") If strPassword "Password" Then MsgBox "Wrong Password": Exit Sub
'This will toggle show / hide the data sheets Application.ScreenUpdating = False For Each Ws In ActiveWorkbook.Worksheets If Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVisible Then Ws.Visible = xlSheetVeryHidden
ElseIf Ws.Name = "Apr-Sep" And Ws.Visible = xlSheetVeryHidden Then Ws.Visible = xlSheetVisible End If
If Ws.Name = "Oct-Mar" And Ws.Visible = xlSheetVisible Then Ws.Visible = xlSheetVeryHidden..........
I have a payroll spreadsheet that is going to be placed on our network server. My boss wants me to have this spreadsheet to be protected so that one person can get in, add hours and commission, and save it up on the server. Then another person can go in to that spreadsheet, open it up to get the info and use it to cut the checks. What my problem is that the person who is making the changes does not need to see the pay rate or the total dollar amount columns, but the person who gets the data out does. Neither one of these people really know how to hide and unhide columns in Excel, so I need it to have when one password opens it, the pay rate and total pay columns are hidden, but the other password will show those columns.
I want to be able to put password protection on a button in a spreadsheet. It doesn't need to be secure, as it's just to prevent accidental changes by 4 year olds.
My plan was to store the password value on a hidden worksheet, as I don't think there's a way to retain the value of a VBA variable when a workbook is closed. Is there a neater way to do it?
Is there a tool that can make an Excel application behave like a “real” software? Meaning, the user will still be able to do what I planned for him to do with the file, BUT it will be very difficult for the more-than-average user to “crack” any password protections I have applied to the file? (Something like an MDE file in Access, perhaps?) The reason I am asking is because I have invested a lot of time and efforts into creating an application that I wish to sell to some of my clients, and don’t want them to easily find their way into the formulas and macros I have placed in the file.
The protection tool does not have to be an Excel tool, necessarily, but it should not require any programming skills (because I don’t have them. If there isn’t such a tool? My application contains User Forms (for input), a Database (with Auto Filters and formulas) and some Pivot Table reports. BTW, my application was created in Excel 2003 but should also be used by users with Excel 2007.
Is there a way to password protect a sheet so that you have to enter a password just to access it. I dont want most users to be even able to view one sheet unless they have the password.
See the attachment. Once you enable it. A userform will ask you for a password. Enter "aes" that will let you in.
My question is, when I enter the wrong password the first time, a userform popsup and asks for the correct the password. once I do place the correct password in the 2nd attempt. The file gets deleted!
It is not suppose to happen. I understand if I entered the password wrong twice the deleteing should take place.
I have a workbook where I need to protect the sheets with a password. However, for certain macros contained in the workbook to run the sheets need to be unprotected. I know the code to unprotect the sheet but the password is required. I do not want other users to know this password.
What I need is the code to protect a worksheet with a password. Then, when a macro runs, to unprotect without user having to enter the password and reprotect with the original password when the macro has completed its run. note: I am NOT looking for any form of password breaking code!!
The spreadsheet basically copies data by looking in all workbooks in different folders (27 in total) and copies the data across. The only problem is that it keeps asking for the password on all of the spreadsheets when it is opening up the files (all have the same password) - how do I get the code to "know" the code and bypass asking for it?
Function LastRow(sh As Worksheet) On Error Resume Next LastRow = sh. Cells. Find(What:="*", _ After:=sh.Range("A1"), _ Lookat:=xlPart, _ LookIn:=xlFormulas, _ SearchOrder:=xlByRows, _ SearchDirection:=xlPrevious, _ MatchCase:=False).Row On Error Goto 0 End Function
i have a spreadsheet with about forty different sheets and all of these sheets are protected with the same password, and wheni come round to doing an amendment to the spreadsheet i have to unprotect and then re protect each sheet in turn, very time consuming
I have a button that executes a macro which basically activates a worksheet. I wish to put a password which would allow only certain users to access this worksheet through this button.
All my macros in Module 1 work OK when I password protect my Excel 2003 worksheet named: Data. The only code that does not work when I password protect my worksheet is the Private Sub shown below. If I do not use a password, it works OK. As soon as I enter a password to protect my worksheet, the code below no longer works.
In ThisWorkbook, the following code shows the password to be password. In reality, there is a different password.
I am trying to change a password on a workbook. I have already gone to encrypt document and changed the password. However, when I open the workbook again, my new password works but another popup shows and asks me for another password for write access. That second password was my original password, and I don't know how to change that.
I`m struggling to insert password protection to code.If Yes is selected from the messagebox then a messagebox opens and asks for a password.
Code: Sub DeleteRanges()
If MsgBox("Are you sure you want to delete data ?", vbYesNoCancel + vbExclamation, "Delete data") = vbYes Then With Sheets("Score") For i = 3 To 273 Step 10 .Range("D" & i).Resize(7, 11).ClearContents Next End With End If
how can you set up a workbook to display different sheets for different users depending upon what password they input to open the workbook? The manager should see all sheets but employees only data entry sheets.
My macros are set up with hard-coded passwords to protect and unprotect the sheets where they run.
But I need a way for the macros to refer to a user-provided password without having the user edit the macos themselves. The simplist approach (I suppose) would be to have a worksheet for this with a cell for the user to enter the password he/she wants. The macro protect/unprotect code would then look at the cell to get the password.
