Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

How Do I Give Password To Open For Excel File?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More





Similar Excel Video Tutorials

Helpful Excel Macros

Close a Workbook after a Time Limit is Reached
- This macro will automatically close the workbook in which it is located after that workbook has been opened for a certai
Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, file vie
Protect and Unprotect All Worksheets at Once
- This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn't allow you to input a passwor
Open a PowerPoint Presentation from Excel
- This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the file
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume

Similar Topics







Hi all,

When i accessing file from shared folder it asking to give the password to open the file.

I knew the password & it has to be give manually every time. Do let me know is there any code to give the password as coding.

Regds,
Nagu




Is it possible to open the encrypted file via vba macro? I encrypted the file with password :MY_PWD and I've to open same file. I tried with ActiveWorkbook.unprotect Password:="My_PWD" in workbook open() event. even if the macro is enabled it asks me to enter the password. can we bypass that problem? wont it take the password from the code or how can we give the password via VBA?

BR
P Sukumaran

dear all,

I have an Excel file whose opening is protected by password.
The file does not open any more, as when I type in the password a message appears that the password is not correct, and the CAPS LOCK can be in.

I remember perfectly the password, and it is confirmed by 2 different programs I have used to inquire the password.

The file has been last viewed some 30 days ago..

Can you help me? Has anybody had this problem?
I am working on Excel 2003 and Windows Vista Professional..

Regards,
Edo


Hey.. I am trying to figure out how to set up a workbook so that all of the following can occur:

1) The workbook is shared
2) It requires a password to open up as editable, otherwise it will open up as read only.
3) If it opens up as editable, it should require another password to be edited except when editing certain columns. (aka, the workbook should be protected except for certain columns).

So to clarify, if I open the file and do not have the password, the only thing i can do is view the data - I cant edit anything. If I have the password to open the file, all I should be able to edit is certain columns, unless I have the separate password to unprotect a sheet which will give me full control.

Is there a way to get all of these things at the same time? Are there any problems when running shared excel files over a network where 2 users are able to edit the file?

Thanks.


Hi all,

I have an excel file that was saved with password. The password is a five digit number but could not remember.

Is it possible to open the file thru a macro by checking the password from 1 thru 99999 (thru loop) as the password. If the file is open with the right password, then loop should terminate.


Thanks


All,

I have a 1.3 meg spreadsheet file in excel (office XP suite). I used
the password protection feature to keep others who share my PC from
being able to open the file at will. Worked fine for a few weeks.

Now when I try to open the file I get the standard message saying file
cannot be accessed... may be read-only... server may be busy.... NONE
of which are true. Excel does not even ask for the password -- never
gets that far. Other excel file open just fine.

How do I force excel to open this file? Is there a switch I can
include with the filename that includes the password ? can I extract
the data? This is a very important file. Any help will be GREATLY
appreciated. TIA,

David

PS., This is my first time trying to open since installing IE 7 beta 3.




All,

I have a 1.3 meg spreadsheet file in excel (office XP suite). I used
the password protection feature to keep others who share my PC from
being able to open the file at will. Worked fine for a few weeks.


Now when I try to open the file I get the standard message saying file
cannot be accessed... may be read-only... server may be busy.... NONE
of which are true. Excel does not even ask for the password -- never
gets that far. Other excel file open just fine.


How do I force excel to open this file? Is there a switch I can
include with the filename that includes the password ? can I extract
the data? This is a very important file. Any help will be GREATLY
appreciated. TIA,


David


PS., This is my first time trying to open since installing IE 7 beta 3.




All,

I have a 1.3 meg spreadsheet file in excel (office XP suite). I used
the password protection feature to keep others who share my PC from
being able to open the file at will. Worked fine for a few weeks.


Now when I try to open the file I get the standard message saying file
cannot be accessed... may be read-only... server may be busy.... NONE
of which are true. Excel does not even ask for the password -- never
gets that far. Other excel files open just fine.


How do I force excel to open this file? Is there a switch I can
include with the filename that includes the password ? can I extract
the data? This is a very important file. Any help will be GREATLY
appreciated. TIA,


David


PS., This is my first time trying to open file since installing IE 7
beta 3.




Hi,

I have a form that opens up with a username and password to open an excel spreadsheet. I would like the form to enter the password into the "file open password" (the normal password prompt for excel to protect workbooks to be opened)

I am not opening another workbook so I cannot use workbook open with password:=xyz etc.

How can I do this?


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. Any ideas?


Hi everyone, i'd like your help to solve a problem i have.

I am no programmer but for work i need to set up an excel file with 4 sheets;

1-the first sheet must be protected with password and visible ONLY for who has the password.
2-opening the excel file the user (whoever he is) must see the sheet 2 as first sheet.
3-when the user clicks on the sheet 1 he can see an empty page (hidden all columns). He needs then to enter the password: if the password is correct the sheet 1 will appear properly, if not, it will stay locked with all columns hidden and no chance to modify it.
4 and main problem- i want to put the password once and never again until the excel file stays open. I had a macro that did the first 3 steps but i lost it and i had to re.enter the password every time i clicked on "sheet 1", which i don't want to do.
5-many people use this excel file, i need to hide the macro with the password for the sheet 1.

I work in an office, my job is not about solving this problem, i'm just an accountancy man, that's why i would really appreciate your help.

thanks!

edit: easier solution you could give me:
i need this behaviour:
i open the excel file and i can see sheet 2, 3 and 4, while sheet 1 is very hidden (or how you say it, i mean you can't even see it). I need a button on sheet 2 that if i press it i will need to enter a password. If the password is correct sheet 1 will be visible (and editable) until i close the excel file. After that i need to hide the VBA code for the button so that nobody can see what's the password behind it.
I think it's really easy for you, this second way.


Hi all -

confused noob here i want to create a function in excel to open a csv file on the web and then do copy and paste. so far so good until my company decided to put password on the link for security reason. my current script (without password) looks like this:

Workbooks.Open Filename:="http://www.ourwebsite.com/folder/samplefile.csv"

it works without password. the question is: how do i script the macro to open this csv file if the link is password protected?

thanks a bunch!
Andy


I just want to start out with I KNOW THE PASSWORD

I am trying to write a macro that will open my workbook that has a password on it, but so far I get stuck after opening with the password box sitting there waiting to be filled in. Is there a way to have the macro fill in the password so that the file will open??? I want to open this file and update it on a macro so I don't have to be here to type in the password!!! HELP!!!

Thanks in advance-
Chrysti


Hi, new to 2007 and we have a spreadsheet that has been sent to us to modify for our purposes. It is password protected, which is fine, we also have the password. We can open and modify the spreadsheet, but we would like to give it a different password. I know you are touchy about passwords and ect so I am trying to ask
1. What does it mean when the password is greyed out? Is that a different level of protection?
2. Does it mean that only the creator can change the password? The help file does not explain anything about this situation.
Thanks in advance.




Hey Guys,

I have a workbook full of password protected files (all different passwords.) I have a main excel file that contains the passwords for each of these files. What I would like this macro to do is to read the password for each file and open the files from the folder. So For instance this is how the password excel file would look:
A B
File XXX Password XXX
File YYY Password YYY

Thus, what I would like is for the macro to read the file name from column A and then open that file and input password that is in column B into the password prompt. Please let me know if this is doable?

Thanks

I have one excel file with SHARE WORKBOOK and 6 to 7 users are opening a single file at the same time. I want to give password to open the each sheet when the user clicks on the sheet. Please help.

Regards

Khot


I am attempting to open a file created by another program and am required to
give a password. I don't know this password and therefore have no access to
the information. The other program has collapsed and will no longer even
recognize the file. Any help would be appreciated!



Hi,

I split the database and fe and be and put a password, the weird thing is that now any file that i open in access prompt me for password and type the same user and password for any file and it will open.

I thought that when you join workgroup file will only ask password for the database i setup for.

what did I do wrong?

thank you


I wonder how I should use the password in Option > Security.

If I give out the password protected file to someone and give out the password as well. That can be easily changed by the user. Is there a way I can have a higher level of password (of course, keep it in my pocket) and still get in?

So my questions is: Is there anyway I can set that password to be a variable so different people have different level of accessibility? Any big picture suggestions is also welcome.

Thanks!


Hello there
No, I'm not looking for a way to find a password. It's almost the reverse.

I have quite a complex file which has code which is password protected. The file works fine but when I save it and close excel, the little message appears asking for the VBA project password. When I click cancel about 20 times it goes away. However for other people who are using it it can be very confusing and offputting. There is a workbook close event but I don't hink it is the problem. I have tried for months to figure out what is causing this and decided it might be an idea to just add a bit of code at the end to give the password.

Is this silly or has anybody any ideas.


I have created a workbook in Excel 2007 and saved as a 97 - 2003 workbook. The file is saved with a password to open and a different password to modify. I have created a hyperlink to this file on my website. The idea being that persons with the first password can open as read only, but unable to modify.
Now when I click on the hyperlink on my websiteto open the file, I am asked for the password to open. When entered correctly, the spreadsheet opens and I can modify the file as I like.
I am not asked for the second password to modify the file, and not asked to open as read only. Same thing happens when I open the file from another PC connected to my website.

Anybody tell me what is wrong.

TIA


No - this is NOT a request to find out how to crack a password!

I have some code in a macro that opens a file and I'm trying to see if it's possible to open said file if it's passworded to open. I'd be grateful if someone could tell me what the syntax would be if the password is, say, BEER and the open command looks like

Workbooks.Open Filename:= "C:\Documents and Settings\My Documents\Book2.xls"

Thanks - i hope I'm making sence...

david


Hello!

So, I have another work issue. I have a spreadsheet that has jobs listed on it, and periodically during the day either I or other users need to go in and update the status of these jobs or add new ones.

Since still more people sometimes want to look at this sheet, but we don't want them to change anything, our solution has been to password-protect the sheet. Easy-peasy, right?

Well I set up the sheet (which is stored on a network drive since we're all over the place) on Friday and things seemed fine -- I was able to open the file from my computer, was given the option to input the password or to open it read-only, and we were good. So were the techs who use the file as well.

But today, I go to open the file and it doesn't even give me the password option, it just automatically opens read-only. When I log out of my computer (as myself) and re-login as if I were one of the techs (who use Macs, btw) then I can open the file and it gives me the password option. But oddly enough, it tells me that it's been locked /by me/ since I set up the need for the password.

I know this should technically work because months ago we had a similar spreadsheet that we had put a password on and it was just fine.

Anybody have any ideas why this is happening? Please let me know if you need any more info. Thanks much, this is probably my favorite work website ever.


Hi all,

My problem is the new 2007 Excel will not read wr1 or other lotus file formats. The 2003 excel version does but it tells me that "you are attempting to open a file that is blocked by your registry policy setting". No search in Excel of the Microsoft could give or define what this means. Some of these old fles are also password protected and that will be a problem as well. Can anyone out there give me some ideas about the Excel error message and how one can get around it the password protect issue. Thanks in anticipation. These files will provide research data for a book I am trying to write. Most important for me and appreaciate any helpers.

regards..bleyzie


Is there VB code to include the entry of a password to open a password protected Excel file? I tried recording the steps but the code that was recorded only showed the File-Open step without any reference to the fact that the password was entered.

Thanks in advance!