getting event notification from an Excel worksheet - C / C++ / MFC Discussion Boards

Slayer8-Oct-02 21:10

8-Oct-02 21:10

Xxx.xxx is createdfile.
in autorun.ini file, write
[autorun]
open=xxx.xxx (if only xxx=exe)
ico=path(if u want to add ico)

or
[autorun]
open=start xxx.xxx(if xxx=bat,txt,...)

//start is the command of cmd.exe

Re: Making Autoruns in C++

Patje8-Oct-02 20:57

Patje

8-Oct-02 20:57

Why not just buy an autorun application, like Autorun Menu Studio.
Look at http://www.softpile.com/Development/Distribution/Review_03051_index.html[^] or www.indigorose.com[^].
Some years ago, version 1 of this product was even free.

Enjoy life, this is not a rehearsal !!!

Win32 + mySQL

Anonymous8-Oct-02 11:22

Anonymous

8-Oct-02 11:22

Hi.

Any tutorial or help docs anywhere on how to create a simple Non MFC Win32 program that can connect to a mySQL database and show/send/delete data from the database?

Thanks for anyhelp. Blush | :O

Re: Win32 + mySQL

Jon Sagara8-Oct-02 11:53

Jon Sagara

8-Oct-02 11:53

Did you try the MySQL++ docs?

http://www.mysql.com/documentation/mysql++/index.html[^]
http://www.mysql.com/downloads/gui-mysqlgui.html[^]

Jon Sagara

Help me out here, Spock. I don't speak stupid.

Link problem #2

algruber8-Oct-02 11:20

algruber

8-Oct-02 11:20

My previous question was my mistake -- of course!
Now I'm setting up a Win32 app as an empty project and then adding 3 files from a game text book.
I get 1 link error:
blackbox.obj : error LNK2001: unresolved external symbol _DirectDrawCreateEx@16
Does this msg mean it can't find ddraw.lib|h?

I'm using VC 6.0 under Windows 98. The program uses directX and I have version 8.1.
I have entered ddraw.lib|h and the other directX files on
Project Settings->Link Tab->Object/library modules.

What am I doing wrong?
Al

Re: Link problem #2

Jon Hulatt8-Oct-02 21:38

Jon Hulatt

8-Oct-02 21:38

Have you installed the directx sdk ? or only the directx runtime?

Signature space for rent. Apply by email to....

Re: Link problem #2

mariuszpopiolek8-Oct-02 21:45

mariuszpopiolek

8-Oct-02 21:45

No, it doesn't mean that VC can't find some file. It mean that it haven't found this function while linking code. It is probably caused by different calling convention of function in header file and in lib file (it seems that in header calling convention is stdcall and in lib is different). Try to find this function declaration in header file, it should be declared with WIN_API macro. After that find DirectDrawCreateEx in lib file. If it doesn't equal to _DirectDrawCreateEx@16 it can't work (then try to delete WIN_API from the declaration of the function, it should help unless the function is defined in lib using another calling convention: fastcall instead of cdecl. If it is defined with fastcall try to declare it with fastcall (but I don't which macro does this Frown | :(

)

Greetings

Mariusz Popiolek

getting event notification from an Excel worksheet

Jim Crafton8-Oct-02 10:20

Jim Crafton

8-Oct-02 10:20

Anyone have any experience of writing a C++ app that has methods that get called when a cell (or cells) in an open Excel worksheet get changed ?
I have been looking here and not found much (and of course, so far MSDN searching hasn't turned up much, but I am still looking...)

Thanks

¡El diablo está en mis pantalones! ¡Mire, mire!

Re: getting event notification from an Excel worksheet

Steve S8-Oct-02 21:59

Steve S

8-Oct-02 21:59

Try looking for automation and excel and MFC, for some hints. I've done something similar to this, monitoring some events. An alternative if it's for a specific workbook is to have some VBA event handling in the workbook.

Steve S
[This signature space available for rent]

Re: getting event notification from an Excel worksheet

Jim Crafton9-Oct-02 3:08

Jim Crafton

9-Oct-02 3:08

Try looking for automation and excel and MFC
Yeah I tried this, and didn't (so far) bring up much useful but I will keep looking.
The VBA is a good point - I could have the vba event handler call out to a COM server I create and then have the server do the rest of the work that needs to happen.

Thanks

¡El diablo está en mis pantalones! ¡Mire, mire!

want to pass in array info to a CDialog from MDI app

ns8-Oct-02 9:30

8-Oct-02 9:30

I spawn a CDialog derived class from my MDI view. I have a member array in the View m_fields[10]. I want to transmit this info to the dialog. If I declare a member array in the dialog called dialogFields[10], how can I from the view class fill it in after creating the object? (It will be modal so no create())

Is this legal? Is there a better way? I'm looking for the simplest mechanism, but am open to more sophisticated techniques for trannsmitting the array info. BOth member arrays are public.

CMyDlg myDlg;

for (int i =0; i < 10; i++)
{
myDlg.dialogFields[i] = m_fields[i];
}

Appreciate your help,
ns

Re: want to pass in array info to a CDialog from MDI app

Nitron8-Oct-02 9:39

Nitron

8-Oct-02 9:39

Stick something like:

CMain* pMain = static_cast< CMain* >(AfxGetMainWnd());
for(int i=0; i<10; i++)
 this->dialogFields[i] = pMain->m_fields[i];

in your OnInitDialog...

Nitron
_________________________________________--
message sent on 100% recycled electrons.

Re: want to pass in array info to a CDialog from MDI app

ns8-Oct-02 9:46

8-Oct-02 9:46

But but but -----this dialog doesnt know anything about the existence of a main or anything. Its off by itself. Do I have to include some .h in the dialog to make it recognise your code?

Appreciate your help,
ns

Re: want to pass in array info to a CDialog from MDI app

Nitron8-Oct-02 9:57

Nitron

8-Oct-02 9:57

Yea,

#include "YourMainViewThatHasThePublicArray.h"

Nitron
_________________________________________--
message sent on 100% recycled electrons.

thanks very much

ns8-Oct-02 9:59

8-Oct-02 9:59

I'l try it...

Appreciate your help,
ns

Re: want to pass in array info to a CDialog from MDI app

JT Anderson8-Oct-02 11:50

JT Anderson

8-Oct-02 11:50

Unless I'm missing something here, the implementation you suggested in your original posting seems superior to the implementation that Nitron suggests. In your implementation, the main window class (let's call it CMainFrame) needs to know about CMyDlg, but CMyDlg needs to know nothing about CMainFrame. In Nitron's suggested implementation, CMainFrame needs to know about CMyDlg and CMyDlg needs to know about CMainFrame. Choose the path with the least linkage.

--------
There are 10 types of people in this world. Those who know binary and those who don't.

Re: want to pass in array info to a CDialog from MDI app

l a u r e n8-Oct-02 13:39

l a u r e n

8-Oct-02 13:39

was thinking that myself

"... and so i said to him ... if it don't dance (or code) and you can't eat it either f**k it or throw it away"
biz stuff about me

Keeping track of control width

Anonymous8-Oct-02 8:25

Anonymous

8-Oct-02 8:25

Hi, I have a control from which I regular need the current width, so I created a member variable. I did override OnSize() to get the new width.

Where do I get the initial width?

Re: Keeping track of control width (?)

Anonymous8-Oct-02 8:58

Anonymous

8-Oct-02 8:58

Well, I remember from my poor Win32 experience that you get a WM_SIZE after the control is created... so overriding OnSize() might be enough?

Propably someone can confirm this? Or is there any other message handler to override and call GetClientRect()?

Re: Keeping track of control width (?)

Roger Allen9-Oct-02 1:48

Roger Allen

9-Oct-02 1:48

Initially you will recieve a WM_SIZE before the control is created, and one after the control is created. You could do the following:

static bool first = true ;
if (GetDlgItem(IDC_OF_CONTROL) != NULL && first)
{
// this code will only be executed once.
CRect size ;
GetDlgItem(IDC_OF_CONTROL)->GetWindowRect(&size) ;
first = false ;
// do something with the initial size of the control
}

Roger Allen
Sonork 100.10016

I think I need a new quote, I am on the prowl, so look out for a soft cute furry looking animal, which is really a Hippo in disguise. Its probably me.

Re: Keeping track of control width

BlackSmith8-Oct-02 9:35

BlackSmith

8-Oct-02 9:35

Try reading here: CWnd::OnGetMinMaxInfo

--BlackSmith--
/*The roof is on fire, we don't need no water, let the MF burn*/. BHG.

Re: Keeping track of control width

Anonymous8-Oct-02 9:54

Anonymous

8-Oct-02 9:54

sorry, I dont get the relation to my question about current control size, which is a client window (a listbox) of a dialog.

Meanwhile I tried with OnSize(), but OnSize() gets called to late. I need to catch the width somewhere earlier, right after the control is created....

Re: Keeping track of control width

8-Oct-02 10:20

Overwriting OnCreate() brought no luck... so I found this one:

void CListBoxLovely::PreSubclassWindow() 
{
	CListBox::PreSubclassWindow();
	CRect rect;
	GetClientRect(rect);
	m_nItemWidth = rect.Width()
}

it works good Smile | :)

frozen combobox

ns8-Oct-02 8:01

8-Oct-02 8:01

This brings up the UI and nothing can be done to it. Cant input anything in the combobox. THe UI is totallly unresponsive to anything:

BOOL CCombobox1View::PreTranslateMessage(MSG* pMsg) 
{

       CString s;

	if   ( pMsg->message == WM_KEYDOWN && pMsg->wParam == VK_RETURN )

		if 	(GetFocus() ==& m_combo1)  
		{
			m_combo1.GetWindowText(s);

			m_combo1.InsertString(0,s);
			m_combo1.SetWindowText("");
			m_combo1.SetFocus();
		//	EndDialog(IDOK);

			
			
			return FALSE; 
		}
		else
		{
	
		}
		

	else
	{ 
		return TRUE;
	}


	return CFormView::PreTranslateMessage(pMsg);
}

Appreciate your help,
ns

Re: frozen combobox

ns8-Oct-02 8:05

8-Oct-02 8:05

I'm just trying to check out the basic functionality of a combobox. I thought that with the code above< I could enter something, then dropdown the box and see it in the list...

Appreciate your help,
ns

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