Check for open Excel document in C++

Question

0.00/5 (No votes)

See more:

I've recently updated our PCs to run Windows 7 32-bit from Windows XP. The code I had used in the past has stopped working and I was wondering what I could do to get it working again.

C++

FileStr.Format("Microsoft Excel - %s  [Read-Only]", pathStr);
HWND hWnd= ::FindWindow(NULL,FileStr);
if (hWnd == NULL)
	ShellExecute(NULL, "open", pseMULTI.m_tProductionTaskfBriefPath, NULL, NULL, SW_SHOWNORMAL);

Obviously Windows have changed the way it window names, and I appreciate that the way I had been doing it was a complete fudge.

Any help appreciated.

Thanks.

Posted 7-Feb-13 23:22pm

punk_legend

Updated 7-Feb-13 23:26pm

Abhishek Pant

v2

Add a Solution

Comments

Matthew Faithfull 8-Feb-13 5:30am

You might have more luck going the COM route, using the Running Object Table to find instances of the root Excel Application Object. You'd need it's ClassId which is public and some IROT client code. I've never actually done it although I've several times thought I would need to and then found an easier way. Maybe that's an indication that you will too.

Richard MacCutchan 8-Feb-13 5:34am

Try opening the file manually with Excel, and check the string you are using is valid. If it still fails then use your debugger to step through your code and see exactly what is happening.

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)

KarstenK · Answer 1 · 2013-02-10T21:52:00

Solution 2

Check for the windows version and do it the "Windows 7" way.

Use Spy++ to detect the right name of the excel-doc

Posted 10-Feb-13 21:52pm

KarstenK

Sayyed Mostafa Hashemi · Answer 2 · 2013-03-28T23:32:00

Solution 3

Hi You must check Process in Task manager by VC++ and use for statement. use GetmoduleFilename and GetModuleHandle.

Posted 28-Mar-13 23:32pm

Sayyed Mostafa Hashemi