Click here to Skip to main content

C / C++ / MFC

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

Madhu Nair12-May-09 21:02

12-May-09 21:02

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

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

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

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

Madhu Nair13-May-09 19:35

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

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

MAPIFindNext return 16 but there are email in Windows Mail.

SNArruda11-May-09 4:42

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?

"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

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."

"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

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."

"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

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:

Roll eyes | :rolleyes:

"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

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

11-May-09 23:54

i need the the code to add

Mohammadj16-May-09 22:19

16-May-09 22:19

it is complicated

it uses user definded messeges etc !~

ty

David Crow18-May-09 3:25

18-May-09 3:25

Mohammadj wrote:
it is complicated

Only because you're making it that way.

Mohammadj wrote:
it uses user definded messeges etc !~

And what is that supposed to mean? Are we not going to be able to read your code as a result? I provided you with code that does 90%, if not more, of what you require. Just how hard is it to come up with the balance?

"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

Mohammadj18-May-09 5:07

18-May-09 5:07

Hi
Can you provide with code needed for it

Reflected message etc user defined message etc

any code necessary and needed to make it work??

David Crow18-May-09 5:10

18-May-09 5:10

Mohammadj wrote:
Can you provide with code needed for it

It's all right here.

Mohammadj wrote:
any code necessary and needed to make it work??

As a programmer, that's your job.

"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

Mohammadj18-May-09 9:11

18-May-09 9:11

Hi
Ty

I,am new can you add the code to http://www.4shared.com/file/105379147/23d04050/dualactionmfcbutton.html[^]

plz

David Crow18-May-09 9:22

18-May-09 9:22

Mohammadj wrote:
I,am new can you add the code to http://www.4shared.com/file/105379147/23d04050/dualactionmfcbutton.html[^]

No I can't. Good luck.

"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

Mohammadj18-May-09 22:01

18-May-09 22:01

helo

Here is the code i made it did not work loll

Sorry

It compiled but it did not work loll

Here is the code i wrote in

void C_Double_Task::OnClicked()
{

DWORD dwpos = GetMessagePos() ;
CPoint pt ;
pt.x = LOWORD(dwpos );
pt.y = HIWORD(dwpos) ;
CRect client_rectangle ;
GetClientRect( client_rectangle) ;
CString strA , strB ;
double db_a ,db_b ;
GetParent()->GetDlgItemText(IDC_NUM1,strA) ;
GetParent()->GetDlgItemText(IDC_NUM2,strB) ;
db_a = atof(strA);
db_b= atof(strB);
double result ;

result = db_b + db_a ;
CRect leftRect ;
leftRect = client_rectangle ;

leftRect.right = client_rectangle .left +client_rectangle.Width()/2;

if(leftRect.PtInRect(pt))
result = db_b - db_a ;

CString Str_result ;
Str_result.Format("%3.2f",result);

GetParent()->SendMessage(UDM_REGION_CLICKED, result);

}

Wink | ;)

Wink | ;)

and

LRESULT CHashiDlg::OnRegionClicked( WPARAM wParam, LPARAM lparan12 )
{
CString resl ;

resl.Format("%3.3",wParam);

SetDlgItemText( IDC_RESULT , resl) ;

return (0);
} Wink | ;)

Wink | ;)

David Crow19-May-09 2:40

19-May-09 2:40

What doesn't work? Does OnClicked() get called? Does OnRegionClicked() receive the message? Is the value of result correct? What does wParam contain?

[edit]
I just made a few changes to that article I pointed you to and it worked fine.
[/edit]

"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

Mohammadj20-May-09 22:24

20-May-09 22:24

Hi
I made this on OnClicked ( the derived custom button)

void C_Double_Task::OnClicked()
{

DWORD dwpos = GetMessagePos() ;
CPoint pt ;
pt.x = LOWORD(dwpos );
pt.y = HIWORD(dwpos) ;
CRect client_rectangle ;
GetClientRect( client_rectangle) ;
CRect leftRect ;
leftRect = client_rectangle ;

leftRect.right = client_rectangle .left +client_rectangle.Width()/2;
IsRight = TRUE ;
if(leftRect.PtInRect(pt))

IsRight = FALSE ;

GetParent()->SendMessage(UDM_REGION_CLICKED, 12);

}

all what do is to set flag if on the right half or left half

LRESULT CHashiDlg::OnRegionClicked( WPARAM wParam, LPARAM lparan12 )
{
UpdateData();

double num1 , num2 , result ;
num1 = atof(m_strNum1);
num2 = atof( m_strNum2);

result = num1 + num2 ;
if (m_two_actions_botn.OnRight() )
result = num1 - num2 ;

m_str_Result.Format("%3.2" ,result);

UpdateData(FALSE);
return (0);

The OnRegionClicked check the flag throught fubction onRight and perform addition or subtraction depending on the value of IsRight ''

it also did not succeed loll

General News Suggestion Question Bug Answer Joke Praise Rant Admin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.