Excel How to open an excel file with a password in VBA

If you have forgotten the password to open the excel file, and the password is a number within 6 digits, you can use the following steps to unlock it (close all programs, for speed):

Open a new Excel, press Alt and F11 at the same time, enter the VBA interface, click on the menu of insert, module, paste it in the new window**:

sub crack()

dim i as long

dim filename as string

i = 0filename = "Excel file (*.)xls & xlsx）,*xls;*.xlsx", ,"VBA crack")

filename = right(filename, len(filename) -instrrev(filename, "\"))

falseline2: on error goto line1

filename, ,true, ,i

msgbox "password is " & i

exit sub

line1: i = i + 1

resume line2

trueend sub

Then press F5 directly in this interface to run this macro, select the file, wait and so on (see the password length).

Recover word password with wordkey.

"wordkey" is a well-known word password recovery tool, which can quickly recover passwords in word documents through methods such as "brute force cracking" and "dictionary cracking". So when you forget the word document password, "wordkey" can be of great help!

Resources. You can get the password of the office document back quickly. Let's take a doc and do a drill.

1. After installing AOPR, launch it, click the open folder icon on the right side of "filename", and select the file that needs to be cracked.

2. "Type of Attack" uses the default "bruteforce attack", and then sets the length and composition of the password.

3. After setting, click "Start Recovery" on the toolbar to start cracking. Later in the process (the length of time has a lot to do with the length of the password set and the complexity of the composition), the password is successfully cracked.

AOPR can not only crack Word files, but also decode document passwords generated by Excel and other office software, and the method is roughly the same.

It's a very simple crack. It is best not to use it illegally. What's your version?

Excel Set Password First Method:

1. Open the password-protected file first. xlsx" file, click the "office button" in the upper left corner;

2. Then select "Save As" - "Excel Workbook";

3. Click "Tools" - "General Options" at the bottom left;

4. After completing the next steps, you can see the pop-up password box, enter the password, open the permission password and modify the permission password, according to your own needs. After the settings are completed, click "OK" and enter the password again.

5. The password has been set, open the file saved as, and there will be a prompt to enter the password.

The second method:

Open the file and click the "Office Button" in the upper left corner - "Prepare" - "Encrypt Document".

Enter the password in the pop-up password box, click OK, and enter the password again.

Once the settings are complete, save the file and open it again and you'll be prompted to enter your password.

Precautions. The password is case-sensitive, pay attention to whether the uppercase keyboard is turned on when entering the password;

If you need to delete the password, repeat the steps of setting the password and remove the password.

Step 1Click on the top left corner to file the file.

Step 2Info - Protect the workbook.

Step 3Encrypted with a password.

Step 4Set a password, OK.

Step 5Re-enter the auspicious bend password, OK.

When you're done, you'll see a pure mess: you need a password to open the workbook and save the file at the end.

When you need to open this file, a prompt box will pop up to enter the password, and you can open it only after entering the correct password

Open the excel file, click "Save as" when the dialog box appears, there is a "Tools" option in the upper right corner, click on the "General" to select the Tongfu grip, open it is to set the password! Hall lift!! Give it a try.

Method steps.

1. Open the Excel file with Excel2007 Macro enabled.

2. Press the Alt+F11 keys at the same time to open the VBA window.

3. View the corresponding ** window, the VBA project on the left.

The project property box corresponds to the corresponding sheet table or module.

4. Click on the corresponding sheet or module name, right-click on it, and select the vbaproject attribute.

5. In the pop-up VBAPROJECT project properties window - Protection tab - check Lock the project when viewing, and enter the password you want to set in the "Password for viewing project properties".

6. Click Confirm, and then click the Save button in the file toolbar.

7. The next time you open the excel file, press alt+f11 at the same time to enter the vba**, double-click the vbaproject file name in the vba project on the left side of the left mouse button, and pop up the vbaproject password input window, enter the password to enter, otherwise you can't view the project password, hehe.