C / C++ / MFC

Re: VC++ Code to check whether an excel file is already open or not

11-May-09 5:13

Hi,
Need source code check whether an excel file is already open or not using vc++ code.

I have searched the net,I do not find any related with this task.Please help as soon as possible

Regards,
Abraham.R

Rajesh R Subramanian11-May-09 5:42

Rajesh R Subramanian

11-May-09 5:42

Have you checked Listing Used Files[^]?

It is a crappy thing, but it's life -^ Carlo Pallini

Re: VC++ Code to check whether an excel file is already open or not

Abraham Betty12-May-09 16:07

Re: VC++ Code to check whether an excel file is already open or not

12-May-09 16:07

Hi Still i am not able to achive it.
I cannot use your dll,can you please tell me any other way i can achieve this requirement ?

Joe Woodbury11-May-09 6:18

Joe Woodbury

11-May-09 6:18

I believe Excel files are locked for writing, so perhaps you could open the file requesting exclusive access.

Anyone who thinks he has a better idea of what's good for people than people do is a swine.
- P.J. O'Rourke

Re: VC++ Code to check whether an excel file is already open or not

Abraham Betty11-May-09 6:39

Re: VC++ Code to check whether an excel file is already open or not

11-May-09 6:39

Hi,
I want to restrict the user to avoid operation on that excel file,when the excel file is in open state.

so i need to indentify by some means to check wether the excel is in open state.

I need to write VC++ Code on this requirement.

Please help.

Regards,
Abraham.R

Joe Woodbury11-May-09 6:50

Joe Woodbury

11-May-09 6:50

There's this utility: http://technet.microsoft.com/en-us/sysinternals/bb896655.aspx Mark used to publish the source and it may still be available somewhere. You could ask on the forums from the sysinternals subsite.

Anyone who thinks he has a better idea of what's good for people than people do is a swine.
- P.J. O'Rourke

Re: VC++ Code to check whether an excel file is already open or not

Madhu Nair11-May-09 8:38

Madhu Nair

11-May-09 8:38

Abraham Betty wrote:
want to restrict the user to avoid operation on that excel file,when the excel file is in open state.
so i need to indentify by some means to check wether the excel is in open state.

I think what Rajesh[^] said is a right choice for you. Smile | :)

Abraham Betty wrote:
I need to write VC++ Code on this requirement.

You can check the Running object table for an already running instance of Excel. Get the properties of the document object to check whether it is your excel file.

You may get the VC++ code and details from this MSDN KB Article[^]

Re: VC++ Code to check whether an excel file is already open or not

Abraham Betty12-May-09 16:18

Re: VC++ Code to check whether an excel file is already open or not

12-May-09 16:18

can you help with some othe option ?

Madhu Nair12-May-09 21:02

Madhu Nair

12-May-09 21:02

Did you try the option which I mentioned in my previous post ?
Using GetActiveObject()[^] ?? Roll eyes | :rolleyes:

to check whether excel is already running or not.

Re: VC++ Code to check whether an excel file is already open or not

Abraham Betty13-May-09 6:52

Re: VC++ Code to check whether an excel file is already open or not

13-May-09 6:52

Hi The one that you have mentioned is VB code. I need to replicate the same in VC++

Thanks in Adv

Madhu Nair13-May-09 19:35

Madhu Nair

13-May-09 19:35

Abraham Betty wrote:
The one that you have mentioned is VB code.

What I mentioned in last post[^] was VC++. Please click on this link to see the same VC++ code for checking whether excel is running or not.

Check this page to know more about Office Automation Using Visual C++[^]

Abraham Betty wrote:
I need to replicate the same in VC++

You can! but have to spend some time over these pages I think.

Re: VC++ Code to check whether an excel file is already open or not

David Crow11-May-09 9:20

MAPIFindNext return 16 but there are email in Windows Mail.

11-May-09 9:20

Abraham Betty wrote:
so i need to indentify by some means to check wether the excel is in open state.

So did you even bother trying to open it?

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

SNArruda11-May-09 4:42

SNArruda

11-May-09 4:42

Hi everybody,

I builted an aplication that read emails from windows Mail. The MAPILogon returns 0, but when a try to send a MAPIFindNext before to use MAPIReadMail the return code is 16. There are emails unreaded in windows mail and i thing that the return code must be 0 for MAPIFindNext.

The windows mail is the default email manager.

I created an email account as "softools" and conected it to samuel.softools@ig.com.br

The MAPI in WIN.INI is 1 and set to MAPI32.DLL. I Loaded the MAPI31.DLL correctly with loadlibrary().

I thing is everything is fine but nothing is heppening

Some can help me ?

Sorry by poor english !

Mohammadj11-May-09 3:39

11-May-09 3:39

Based on http://visualcsamples.blogspot.com/2009/04/visual-c-examples-hover-button-with-two.html[^]

iam trying to build a dual function double functions button

ie , if clicked on the right half perform differnt action than if clicked on the left half

Any ideas?

David Crow11-May-09 4:32

11-May-09 4:32

Mohammadj wrote:
Any ideas?

Something similar to this?

Mohammadj11-May-09 9:06

11-May-09 9:06

Thanks

What I want is to add dual functions to it

like multiply divide on the same button or Fahrenheit To Celsius and vice versa on the same button

The one you showed displays different texts not what I want

Thanks

David Crow11-May-09 9:09

11-May-09 9:09

Mohammadj wrote:
like multiply divide on the same button or Fahrenheit To Celsius and vice versa on the same button

The one you showed displays different texts not what I want

You seem to be contradicting yourself. "Multiply" and "Divide" are different, as are "Fahrenheit" and "Celsius."

Mohammadj11-May-09 9:15

11-May-09 9:15

As you can see the button have 2 hover states

What I intent to do

if the user clicked on the left half the button perform division or Fahrenheit to Celsius if the user clicked on the right half the button perform multiplication or Celcius to Fahrenheit

The button perform 2 operations depending which half you click

TY

David Crow11-May-09 9:19

11-May-09 9:19

Mohammadj wrote:
The button perform 2 operations depending which half you click

Which is exactly what the article I pointed you to does, although it has 8 "sides."

Mohammadj11-May-09 9:21

11-May-09 9:21

it just displays different text loll

i want the button to perform 2 actions

David Crow11-May-09 9:27

11-May-09 9:27

Are you that inept that you cannot figure out that if the code is currently figuring out which one of eight sides of a button is being clicked and performing a single action (e.g., updating a listbox), it could easily be changed to perform eight separate actions instead? Roll eyes | :rolleyes:

Mohammadj11-May-09 9:28

11-May-09 9:28

Maybe

Mohammadj11-May-09 20:27

11-May-09 20:27

I want code snippets to add!#?

Mohammadj11-May-09 23:54