Hello I have to click 'ok' in excel file that showing a dialogbox during its open , how to ok programitically

Question

4.00/5 (1 vote)

See more:

click-ok excelfile dialogbox through programming.

[EDIT]
i want password recovery of excel vba .i did half of recovery process .But when i am opening excel vba file after opening that showing a dialogbox that i have to click ok .So that i am asking how to click it ok through code because i have to do it through code only .Manually its easy .
[/EDIT]

What I have tried:

please help for excel file dialog box click

Posted 1-Apr-18 0:25am

gelsmith

Updated 2-Apr-18 21:53pm

Maciej Los

v2

Add a Solution

Comments

Afzaal Ahmad Zeeshan 1-Apr-18 9:39am

Are you showing the dialog where you need to press Ok, or do you want to press Ok on someone else's dialog in this?

Dave Kreskowiak 1-Apr-18 10:50am

That depends on what the dialog is saying, where the dialog is coming from, and what you're code is written in (VBA in Excel, external C# or VB.NET code, ...), none of which you explained.

gelsmith 2-Apr-18 5:05am

i have did most of work for vba password recovery .But when i am manually opening excel vba that time it showing a dialog box that i have to click ok through code how can i do .

Dave Kreskowiak 2-Apr-18 8:44am

You can't. Not from Excel VBA code. Your code is stopped while the dialog box is open.

If you're trying to brute force guess the password by trying every combination of letters and numbers, you're going to be there for a VERY LONG TIME. Trying to open the Excel sheet and guessing the password on just a single workbook may very well exceed your lifetime. The problem there is you're introducing the overhead time of opening Excel and telling it to open the workbook.

Your approach to "cracking", not "recovering", the password is naive at best.

gelsmith 2-Apr-18 5:05am

through excel automation code can you help me

Richard MacCutchan 2-Apr-18 5:34am

What sort of programming and language are you talking about?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Answer 1 · 2018-04-01T23:45:00

Solution 2

Quote:
click-ok excelfile dialogbox through programming.

Short answer: you don't.
Basically, your mystery dialogbox, just like any excel dialogbox, is modal, this mean that vba is stopped as long as the dialogbox is waiting for an answer. Thus it prevent vba from automating the dialogbox.

Posted 1-Apr-18 23:45pm

Patrice T

Comments

Maciej Los 2-Apr-18 13:42pm

5ed!

Patrice T 2-Apr-18 15:32pm

Thank you

Maciej Los · Answer 2 · 2018-04-02T21:55:00

According to the documentation, a Workbooks.Open Method (Excel)[^] gets several parameters. One of them is a Password.

Quote:
A string that contains the password required to open a protected workbook. If this argument is omitted and the workbook requires a password, the user is prompted for the password.