Prompte Plugin Password When Open File
Aug 17, 2006
When I opened up the excel file, it prompted me to plugin password. There is no read-only option too. how can i open it up, i tried download some password
protector software to crack it, it is only limited demo which mean can open that file partially not full indeed
View 3 Replies
ADVERTISEMENT
Oct 22, 2009
I have a macro that opens Spreadsheet_A, copies the contents to Spreadsheet_Master, closes Spreadsheet_A, then repeats the process for Spreadsheet_B then ss_C then ss_D etc etc etc.....
Each spreadsheet is password protected, and the password is the same for all spreadsheet to stop casual browsing only. I have set the password.
When I run the macro, I have to type the password in each instance, ie 20 or more times for 2 or more files.
Anyone know the code to insert so the spreadsheet opens without my typing the password.
[It's Excel 2007, but I presume the same code as Excel 2003]
View 9 Replies
View Related
Feb 5, 2013
I have a certain .xls file which is password protected.
Now i have forgot the password for opening the file. Is there any other way of opening the file without password or using a Macro.
View 2 Replies
View Related
Jun 24, 2014
I have the following line of code to open a file and enter the password to allow modifications.
When I run the code the file opens but then the password isn't entered.
View 2 Replies
View Related
Dec 5, 2012
How can I remove open password from an excel file having version 2003 without any software.
View 3 Replies
View Related
May 31, 2013
I've got a spreadsheet that has password protection before you can "modify" it. All of a sudden today, when I open the spreadsheet and enter the correct password, it still opens but only as Read Only.
View 3 Replies
View Related
May 27, 2009
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.
View 11 Replies
View Related
Apr 14, 2006
I have been using MSNStockQuotes on a few computers without any problems for months.
Now (in the last day or so) , when I press "update Quotes" on any of the computers, I get a "Failed to get requested Data" message. I can often "trick" it into getting the quotes by deleting a bunch of the quotes, then choosing Edit-Undo, which then fetches the quotes properly, but even that fails some of the time (same displayed message).
This happens even with older copies of my spreadsheet that used to work perfectly.
Are others having problems with MSNStockQuotes Excel Plugin?
View 13 Replies
View Related
May 31, 2013
I have a tool file which contains Excel VBA codes. When I click button it asks to select a file. I want that anytime I click the button the dialogue box should open in the folder containg the tool.,
View 1 Replies
View Related
Dec 9, 2006
I have an existing application that uses DAO sql queries to populate a form. It has always worked fine. Earlier this week, I password protected the spreadsheet. Now my DAO query fails. I get a run-time error '3161'. Could not decrypt file.
' Const stExtens As String = "Excel 8.0;HDR=Yes;"
Const stExtens As String = "Excel 8.0;HDR=Yes;PWD=money16;"
Private Sub Execute_Query(SQL)
'Instantiate the DAO objects.
strDb = ThisWorkbook.FullName
Set DAO_ws = DBEngine.Workspaces(0)
' code fails on the line below
Set DAO_db = DAO_ws.OpenDatabase(strDb, False, True, stExtens)
Set DAO_rs = DAO_db.OpenRecordset(SQL, dbOpenForwardOnly)
End Sub
View 3 Replies
View Related
Jan 9, 2009
A little unrelated to excel as such but helpful to many of us I think. How to set a password to open/ view any folder or directory?
View 2 Replies
View Related
Apr 19, 2006
I am just wondering if it is possible to insert a module or a code such that it is user specific.
In detail, there are two types of users: Administrator and User.
If it were administrator, it should ask for a password. If user, it should give the read-only or a protected form of the spreadsheet.
I just need the workbook to pop-up with a msgbox of administrator/user with a radio button or a select button. If administrator, it should ask for a password. Also, disabling the macros should not open the spreadsheet as making this would lead to nothing.
View 3 Replies
View Related
Jul 22, 2008
I know of the password protect feature to open a excel file or workbook, but does anyone know if this can be done for opening a worksheet.
I want to be able to view a worksheet after a password is entered, so therefore different worksheets have different passwords.
View 9 Replies
View Related
Apr 28, 2014
i have one page with 6 different links, each link will open one worksheet , i want to set password to each link to open there worksheet , i can update my file if it's required .
View 14 Replies
View Related
Nov 7, 2011
Code:
Sub Open_Test_File()
Dim wb As Workbook
Set wb = Application.Workbooks.Open("DesktopTest File.xls")
End Sub
This very simple little code opens a new workbook.
But if I add a password to the file that I'm going to open the password box appears.
What do I need to add to this code to automatically input this password?
I have tried putting this at the end:
Code:
Password:="123"
but this does not work?
View 2 Replies
View Related
Jan 17, 2013
I have a sheet which i made ages ago and cant remember my pw. I can goto the alt, F11 select the macro and run it which i have set from all sheets to hide, and i can change the wording on the sheets but i cant open the code.
Does this mean i will have to forget about it unless i remember the pw?
View 1 Replies
View Related
Jun 18, 2013
I inherited a spreadsheet from a recently let go co-worker. This spreadsheet has a lot of important financial data on it, so I really need to get into the spreadsheet. we contacted the former employee and he said he forgot the password. Is there any work around to get into the sheet?
View 2 Replies
View Related
Jul 23, 2006
I need to know weather it is possible to change the "Password protected workbook" box upon file open with a custom user form. I know you can because you can change and disable the "Save As" box etc. I dont mind using the code with a certificate to open the workbook but id prefer not to...
View 9 Replies
View Related
Jul 25, 2007
I have a workbook with the following
Sub Workbook_Open()
Sheets("Occ-Rent-Concess Worksheet").Select
ActiveSheet.Unprotect Password:="pass"
ActiveSheet.Select
Cells.Locked = True
ActiveSheet.Protect Password:="pass"
pass:
UserName = InputBox("Enter Log On Name to Continue..............................................
This code opens a msgbox that asks for a password and then unlocks certain cells based on what the password is. I have 140 of these workbooks. I need to be able to open them all and change one cell in each file, save it and close. I've gotten the macro written to open, change and save the files, but I am still having to type the 'password' 140 times. Is there a way to bypass it?
View 4 Replies
View Related
Mar 5, 2008
I have not asked for this Dialog Box, but it appears when I open the workbook.
I must have done some strange things - hope someone can give me a hint.
I have attaced a picture of the Dialog Box.
View 9 Replies
View Related
Sep 28, 2006
I am having a workbook in server, it consists more than 12 sheets. Everyday in the early morning it need to be get updated, (i.e) normally when i open the file, it as for the Password (password for workbook), then after I given it will show three buttons Update Don't Update Help, so i need to press the Update Button , it should be done everyday in the early moring.
Is there any way to do this automatically open and update and close everday through vba code or anyother ways.
View 9 Replies
View Related
Aug 8, 2014
I have a spreadsheet (don't we all) that is currently password protected - you double click the file and need to input a password before it will open.
I have some code that will protect a workbook from changes and only unlock for specific usernames, and i wonder if there is some code that will do the following:
-User opens spreadsheet
-VBA looks at the username trying to open the sheet, for this example the username is Paul.Smith
-Paul.Smith is not one of the people who should have regular access to this sheet - so the VBA requests a password from him prior to opening the sheet.
My username opens the same sheet (galvin.paddy), VBA see's that my name is one of the 'Authorised Users', removes the password and opens the sheet for me ready for use.
View 14 Replies
View Related
Feb 20, 2012
I open a program using code
Code:
Call Shell("C:Program Files...
After this is open i have to type my password, how can i create a macro to open the program as above then type my password then hit enter.
to sum it up
i can open the program
i need code to type in the open program and hit enter.
View 4 Replies
View Related
Jul 18, 2005
Trying to find a set of code that I can use to open a website that's predetermined, and enter in the users name and password automatically. And if possible, open a new email via the website, addressed to a person, and ready to browse for the file to attach.
The code I have is below.
Private Sub CommandButton1_Click()
'
storenumber = [$c$3]
If [$iv$2] = True Then
If [$iv$3] 0 Then
MsgBox ("Can't send with No Adjustments Checked & Items to Adjust, Please clear one")
End
End If
End If..................
View 9 Replies
View Related
Oct 18, 2008
I want to create a macro that will �open the look in list� and stop so I can pick a file to open. I�ve tried to use �record a macro� and �ctrl-o�, but the record a macro won�t stop until I pick a file or cancel the file list. I also tried to use �o� in the short cut key box
View 5 Replies
View Related
Apr 22, 2009
upon opening my spreadsheet which will only open if the correct answer/ password is typed.
I�d need to store the questions, passwords/ answers somewhere for VB to look up I guess??
Capital of England � London
Capital of France � Paris
Capital of Italy � Rome
Etc etc
And then I need coding which will open one of the random questions, which will only grant access to the spreadsheet if the correct answer is typed.
View 9 Replies
View Related
Jul 25, 2012
I am having an issue with a macro to open password protected workbooks. The macro works just fine in opening the files and whatnot, but for some reason it prompts me to enter the password again once the file has been opened. Funny thing is I can either hit OK or hit Cancel and it goes to the next file. All files open correctly, I was just curious as to why this is happening and how to correct it?
View 1 Replies
View Related
May 14, 2009
I have two workbooks. One is a no-nonsense form interface that my bosses will use to enter safety information. I'll call this workbook "Form". This file is stored locally on each of their computers. The other workbook is stored on a common drive. I'll call it "Master".
When my bosses fill out the Form and click "Submit", the Master file is opened, and certain cells are populated based on information entered in the Form. This is the code I am using to make this happen:
View 5 Replies
View Related
Jul 3, 2007
I'm doing the following:
Dim myname As String
myname = Application. GetOpenFilename
I use it to attempt to open first a QuickBooks file and then an excel workbook.
The Quickbooks file opens fine. The Excel workbook never appears to open but
I do get the full file pathname to my excel workbook returned which I then
parse off to get just the workbook name.
Why would it behave this way? I open both these files manually all the time.
Also, I'm trying to use a filter as follows:
myname = Application.GetOpenFilename("*.QBW")
I get a compile error saying that I'm calling the function wrong.
View 5 Replies
View Related
Feb 16, 2010
I searched the forumn but didn't find thread sorry for creating new thread.
frends i have 2 questions.
1) How to put password for excel file (2003) ? (not for sheet)
2) How to remove password from excel file ? (if its not break forum rule).
View 3 Replies
View Related