Re: Using Excel data in VC++ 6.0 - C / C++ / MFC Discussion Boards

Rob Manderson27-May-04 12:41

27-May-04 12:41

smbecker wrote:
#pragma comment(lib, "Advapi32")

change to

#pragma comment(lib, "Advapi32.lib")

Rob Manderson

I'm working on a version for Visual Lisp++

Re: CreateProcessWithLogonW

cobyjone28-May-04 3:48

cobyjone

28-May-04 3:48

I made the change and I am still getting the same linking error as before. Any other suggestions? Thanks

Changing Size Font and Vertical Scroll Bar

Eversman27-May-04 10:16

Eversman

27-May-04 10:16

Hey all,

I got 2 questions.

1st one is how do you change the size of a CString? I have tired and I couldn't get it, here is what I have tried.

<br />
CFont font;<br />
   font.CreatePointFont(480, "Arial", &dc);<br />
<br />
<br />
   CString str("DEP");<br />
<br />
   CSize size = dc.GetTextExtent(str);<br />
<br />
	dc.DrawText(str, printArea, DT_NOPREFIX | DT_WORDBREAK);<br />
<br />

2nd question is how do you get a Veritcal Scroll Bar to work? I know how to add it to a Dialog, but can't get it to scroll.

Thanks for the help

Re: Changing Size Font and Vertical Scroll Bar

gUrM33T27-May-04 15:07

gUrM33T

27-May-04 15:07

Before a call to the device context functions, you need to select the graphics object(s) you need to work with; in your case, a CFont object. Write the following statements before and after a call to the DrawText(...) function respectively:

Before
CFont *pOldFont = dc.SelectObject(&font);

After
dc.SelectObject(pOldFont);

Gurmeet

BTW, can Google help me search my lost pajamas?

My Articles: HTML Reader C++ Class Library, Numeric Edit Control

Using Excel data in VC++ 6.0

greg8927-May-04 9:31

greg89

27-May-04 9:31

I am trying to access an Excel spreadheet in Visual C++ 6.0. I am using the XL5EN32.OLB library. However I keep getting errors, one of which is:

error C2440: 'type cast' : cannot convert from 'class Sheets' to 'class COleVariant'

I just wanted to be able to pull data out of a spreadsheet and use it in my program. There are problems with Ole. I thought you could define a sheet from the workbook object. However it does not allow me to do this. You have do get sheets from a workbook and a workbook from a file. But I can not do this, the return types don't match. I looked at MSDN article 179706

http://support.microsoft.com/default.aspx?scid=kb;EN-US;179706

It doesn't seem to work that way though. I don't know how they got the return types to match.

COleVariant fn;
CString f;
Application app;
Workbooks books;
Workbook book;
Range pRange;
Sheets sheets;
double Result;
COleVariant
covTrue((short)TRUE),
covFalse((short)FALSE),
covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);

app.CreateDispatch("Excel.Application");

app.SetVisible(covTrue);

books.Open(fn, covOptional, covOptional, covOptional, covOptional,
covOptional, covOptional, covOptional, covOptional,
covOptional, covOptional, covOptional);

sheets = book.Sheets(COleVariant((short)(1)));

Re: Using Excel data in VC++ 6.0

Anthony_Yio27-May-04 17:47

Anthony_Yio

27-May-04 17:47

There are some internal logic that you need to handle.

The way to correct this is.

LPDISPATCH lpDisp;
lpDisp = book.Sheets(COleVariant((short)(1)));

 ASSERT(lpDisp); //some checking
 sheets.AttachDispatch(lpDisp);

I have not tested it but it should be that kind of style down the road using AttachDispatch(...)

Sonork 100.41263:Anthony_Yio

Life is about experiencing ...

Re: Using Excel data in VC++ 6.0

greg8928-May-04 2:33

greg89

28-May-04 2:33

I get the following error when I try

LPDISPATCH lpDisp; lpDisp = book.Sheets(COleVariant((short)(1))); ASSERT(lpDisp); //some checking sheets.AttachDispatch(lpDisp);

error C2679: binary '=' : no operator defined which takes a right-hand operand of type 'struct tagVARIANT' (or there is no acceptable conversion)

Re: Using Excel data in VC++ 6.0

Anthony_Yio28-May-04 19:00

Anthony_Yio

28-May-04 19:00

Try

//I am sure there are some elegant ways to do these
 //conversions. Looks like a mess for me but heck, I do not 
//have a test environment off hand for this. 

 LPVARIANT lpVar = (book.Sheets(COleVariant((short)(1)))).operator LPVARIANT( ); 

LPDISPATCH lpDispatch;

if(lpVar->vt == VT_DISPATCH)
{
 lpDispatch = lpVar->ppdispVal;
}
else
{
 //error
 ASSERT(NULL); 
}

sheets.AttachDispatch(lpDisp);

Sonork 100.41263:Anthony_Yio

Life is about experiencing ...

EndModalDialog?? Any Ideas

Cedar Sith27-May-04 7:15

Cedar Sith

27-May-04 7:15

I have a modal dialog box that I would like to go modaless if a button is clicked on and then back to a modal state after the buttons action has ended.

I have tried EndModalDialog but with no success, does anyone know a command that can help me?

Re: EndModalDialog?? Any Ideas

Anthony_Yio27-May-04 16:54

Anthony_Yio

27-May-04 16:54

Just call yourDialog.DoModal() for modal dialog.

and yourDialog.Show() for modeless.

There are plenty of tutorials on modeless dialog in codeproject.

Sonork 100.41263:Anthony_Yio

Life is about experiencing ...

Re: EndModalDialog?? Any Ideas

Cedar Sith28-May-04 3:01

Cedar Sith

28-May-04 3:01

I want the Dialog Box to be modal unless the button is clicked.

If they never click the button then the dialog box should just be
modal the entire time.

What I am trying to do is: if a user clicks on a button then it opens a doc/view window where they can make a choice that sends them back to the dialog box which would return to its modal state.

Thanks

Re: EndModalDialog?? Any Ideas

Anthony_Yio28-May-04 19:06

Anthony_Yio

28-May-04 19:06

I think Gary R. Wheeler suggestion is implementable.

Like

((YourParentDlg*)this->GetParent())->EnableWindow(FALSE);

Anyway, I think the logic behind is and should lie under you.

Sonork 100.41263:Anthony_Yio

Life is about experiencing ...

Re: EndModalDialog?? Any Ideas

Gary R. Wheeler28-May-04 5:25

Gary R. Wheeler

28-May-04 5:25

Probably the easiest way to do this is to have the dialog be modeless all of the time, and then simulate modality by having the dialog disable/enable the parent window as necessary.

Software Zen: delete this;

ALT+TAB functionality.

baskarchinnu27-May-04 7:06

baskarchinnu

27-May-04 7:06

Hi,

I am working on win32 api, I want to apply ALT+TAB functionality for our programming. Actually I want to get the taskbar running application. ALT+TAB functionality is fulfilling, so can u one please send me a suggestion to get handle of the application, which is running on taskbar only.

Thanks in Advance

Baskar

Re: ALT+TAB functionality.

Alexander ^M.,27-May-04 8:34

Alexander ^M.,

27-May-04 8:34

i don't understand. what do you want? get the HWND to the task bar? get the process id to the process controlling the task bar?

Don't try it, just do it! Wink | ;-)

Re: ALT+TAB functionality.

baskarchinnu27-May-04 21:23

baskarchinnu

27-May-04 21:23

Hi Alxander,

Thanks for your immediate reply for the same. I need to get all top level windows to show the application icons on our product. In our product we are having one tooltip window, which is used for display all icons of top level windows (all taskbar application windows). It seems like ALT+TAB window. Samething like I need to create one window inside our product. For that I need to get all top level windows. Can u please help the same how to get top level windows.

Thanks in Advance

Baskar

how to add a minimize button and maximize button on a dialog?

vividtang27-May-04 6:39

vividtang

27-May-04 6:39

the following is my doing:
in precreatewindow()
cs.style|=MINIMIZEBOX;
but doesnt work,somebody can give me some advice and explanination?
thx

Re: how to add a minimize button and maximize button on a dialog?

David Crow27-May-04 7:05

David Crow

27-May-04 7:05

Are you creating the dialog at runtime, or toggling the min/max on and off buttons while the dialog is running?

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

Re: how to add a minimize button and maximize button on a dialog?

Alexander ^M.,27-May-04 8:41

Alexander ^M.,

27-May-04 8:41

there are 2 better ways. if you are using a dialog resource then change the dialog settings with the resource editor (there is an option for min/max button). the other way is to change the window style run-time.

DWORD dwLong;

dwLong = GetWindowLong( hWnd, GWL_STYLE );
dwLong |= WS_MINIMIZEBOX | WS_MAXIMIZEBOX;
SetWindowLong( hWnd, GWL_STYLE, dwLong );

Don't try it, just do it! Wink | ;-)

Re: how to add a minimize button and maximize button on a dialog?

J.B.27-May-04 17:00

J.B.

27-May-04 17:00

If in MFC, I think ModifyStytle() works the same way.

<code>
ModifyStyle(0, WS_MINIMIZEBOX | WS_MAXIMIZEBOX);

I have a little problem when making this style changes in run time tho. I placed it at the end of OnInitDialog() and the changes is made sucessfully. But at the first time the dialog appears, the MAXIMIZE and MINIMIZE icons (just the icons) are still on the menu bar, until the window is refreshed (e.g. switch to other dialog and switch back). Is this normal?

DDE Server

orcun colak27-May-04 5:20

orcun colak

27-May-04 5:20

Is there a way of enumerating DDE Servers on a computer?
I would like to see which programs accept DDE messages on my local computer?

Orcun Colak

Re: DDE Server

David Crow27-May-04 7:13

David Crow

27-May-04 7:13

Is DdeConnectList() of any help.

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

Install the .Net framework

sweep12327-May-04 5:04

sweep123

27-May-04 5:04

I have developed a Simple MFC GUI to allow a user to display and control an activity.
The program works fine on a PC with Visual Studio installed, but when I transfer the program
to a Laptop computer I get an Assertion Failure line 410 of file occmgr.cpp.

I built a Deployment & Install project to formally install the program, but still keep getting the same error. It works fine on a desktop PC without Visual Studio installed.

I was told that Assertions are present only in debug builds, and debug builds cannot be
and should not be deployed.

I have now built the application in 'Release' mode, but now need to install the .Net framework.

How do you do that?!? Confused | :confused:

Re: Install the .Net framework

valikac27-May-04 5:11

valikac

27-May-04 5:11

Check out commercial installer such as InstallShield. It can package the .NET runtimes. You can give the user the link to download .NET Framework at MSDN.

Kuphryn

Re: Install the .Net framework

toxcct27-May-04 5:29

toxcct

27-May-04 5:29

it is because you built your application with Visual studio .NET, and the user that execute then don't have this framework.
run windows update and search for the .NET framework

TOXCCT >>> GEII power

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