Re: Combo box Max Length - C / C++ / MFC Discussion Boards

Re: reading simple excel sheet without using odbc

Karismatic18-Sep-07 23:07

18-Sep-07 23:07

Using this code you can get the values from xl sheet in the variant variable var.

There are step to use this code: -
1. write the import statements acording to the verision of office u have
for office 2000 they are: -

<br />
#import "Lib\mso9.dll" no_namespace rename("DocumentProperties", "DocumentPropertiesXL") <br />
<br />
#import "Lib\vbe6ext.olb" no_namespace<br />
<br />
#import "Lib\Excel9.olb" \<br />
	rename( "DialogBox", "ExcelDialogBox" ) \<br />
	rename( "RGB", "ExcelRGB" ) \<br />
	rename( "CopyFile", "ExcelCopyFile" ) \<br />
	rename( "ReplaceText", "ExcelReplaceText" ) \<br />
	rename_namespace("EXL")<br />

Best place to add these statements is in stdafx.h

2.Declare these variables: -

<br />
	// excel variables.<br />
	EXL::_ApplicationPtr pEXLApp;<br />
	WorkbooksPtr pEXLBooks;<br />
	_WorkbookPtr pEXLBook;<br />
	WorksheetsPtr pEXLSheets;<br />
	_WorksheetPtr pEXLSheet;<br />

<br />
::CoInitialize(NULL);<br />
try<br />
{<br />
	if(NULL == pEXLApp)<br />
		hResApp = pEXLApp.CreateInstance("Excel.Application");<br />
	else<br />
		hResApp = pEXLApp.GetActiveObject("Excel.Application");<br />
<br />
	pEXLBooks = pEXLApp->GetWorkbooks();<br />
	pEXLBook = pEXLBooks->Open(_bstr_t("Path of the xls file"));<br />
	pEXLSheet = pEXLBook->GetActiveSheet();<br />
<br />
	_variant_t var = pEXLSheet->GetRange("A1")->GetFormulaR1C1();<br />
<br />
	pEXLApp->GetActiveWindow()->Close();<br />
}<br />
catch(_com_error &e)<br />
{<br />
	string strError;<br />
	_bstr_t bstrSource(e.Source());<br />
	_bstr_t bstrDescription(e.Description());<br />
	_bstr_t bstrError(e.Error());<br />
<br />
	_bstr_t err_msg = "Error : " + bstrError + "\nDescription : " + bstrDescription + "\nSource : " + bstrSource;<br />
<br />
	strError = _com_util::ConvertBSTRToString(err_msg);<br />
	AfxMessageBox(strError.c_str());<br />
}

Regards,
Pankaj Sachdeva

"There is no future lies in any job"
"but"
"future lies in the person who holds the job"

Convert char string to UTF-8

kcynic18-Sep-07 21:25

kcynic

18-Sep-07 21:25

I want to convert char[] string to UTF-8.
How should I use int MultiByteToWideChar() and WideCharToMultiByte() to do such convertion?
And if I should not use the two function to resolve such task,but how should I do?
Thanks.

GOOD LUCK

Re: Convert char string to UTF-8

fefe.wyx18-Sep-07 23:13

fefe.wyx

18-Sep-07 23:13

First use MultiByteToWideChar() to convert the char string from your local code page to wide char, then use WideCharToMultiByte() to convert the wide char string to UTF8. You may use CP_ACP for your local code page, and code page for utf-8 is 1200.

But I've never tried the conversion between wide char and utf-8, so I'm not sure whether it would succeed.

Re: Convert char string to UTF-8

kcynic19-Sep-07 15:00

kcynic

19-Sep-07 15:00

I also do not want to convert the string to UTF-8.But I use the "libipod"(a opensource code of iPod),it use utf-8 and utf-16!

Re: Convert char string to UTF-8

KarstenK18-Sep-07 23:46

KarstenK

18-Sep-07 23:46

it is good style to use the API-functions, because they do really a good job in checking different parameters and conditions.

But they are hungry for parameters. Dead | X|

Greetings from Germany

Combo box Max Length

danasegaranea18-Sep-07 21:02

danasegaranea

18-Sep-07 21:02

Hi all,
How can set the max length of a combo box to 50 charcters only

Thanks in Advance
Dana

Re: Combo box Max Length

nbugalia18-Sep-07 21:13

nbugalia

18-Sep-07 21:13

use CComboBox::LimitText

Re: Combo box Max Length

Nelek18-Sep-07 21:13

Nelek

18-Sep-07 21:13

From the MSDN Help:

CComboBox::LimitText
BOOL LimitText( int nMaxChars );

Return Value

Nonzero if successful. If called for a combo box with the style CBS_DROPDOWNLIST or for a combo box without an edit control, the return value is CB_ERR.

Parameters

nMaxChars

Specifies the length (in bytes) of the text that the user can enter. If this parameter is 0, the text length is set to 65,535 bytes.

Remarks

Limits the length in bytes of the text that the user can enter into the edit control of a combo box.

If the combo box does not have the style CBS_AUTOHSCROLL, setting the text limit to be larger than the size of the edit control will have no effect.

LimitText only limits the text the user can enter. It has no effect on any text already in the edit control when the message is sent, nor does it affect the length of the text copied to the edit control when a string in the list box is selected.

Hope it helps

Greetings.

--------
M.D.V.

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?

Help me to understand what I'm saying, and I'll explain it better to you

Wink | ;)

Re: Combo box Max Length

danasegaranea19-Sep-07 0:03

danasegaranea

19-Sep-07 0:03

Thanks all,
I am new to VC++.Trying to set that property but not able to do so.

Dana

dierect show

amiya das18-Sep-07 20:37

amiya das

18-Sep-07 20:37

hi,

in advance thanks to look my problem,

i am executing pushsource program which is in platform sdk. i am getting some errors while linking. i dont know what to do i have already included strmbasd.lib in the project library and the path is also set.

can any one help me how to get rid of this errors.

the following errors i am getting.
Linking...
LINK : fatal error LNK1221: a subsystem can't be inferred and must be defined

PushSource - 1 error(s), 0 warning(s)
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

can any one help me how to solve it.

amiya kumar das

Window questions

Programm3r18-Sep-07 20:29

Programm3r

18-Sep-07 20:29

Hi all,

How can I perform the following actions programmatically ?

Perform the 'Open Containing Folder' action as when one right clicks on a searched file

Show the properties window of a file

Create a shortcut to a file

Many Thanks in advance
Regards,

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Window questions

Programm3r18-Sep-07 20:49

Programm3r

18-Sep-07 20:49

Programm3r wrote:
Perform the 'Open Containing Folder' action as when one right clicks on a searched file

Why does this work:

explorer.exe /select, C:\MyDir\MySubDir\File.extension

And this does not

explorer.exe /select, C:\\MyDir\\MySubDir\\File.extension

Confused | :confused:

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Window questions

toxcct18-Sep-07 23:43

toxcct

18-Sep-07 23:43

Programm3r wrote:
Why does this work:

explorer.exe /select, C:\MyDir\MySubDir\File.extension

And this does not

explorer.exe /select, C:\\MyDir\\MySubDir\\File.extension

because you're in the "Run..." windows, and not in your code, aren't you ?

the \ character is needed as the escapment character only in the source code, not in "running life"...

[VisualCalc][Binary Guide][CommDialogs] | [Forums Guidelines]

Re: Window questions

GauranG Shah19-Sep-07 1:56

GauranG Shah

19-Sep-07 1:56

First tell me where r u using this ?? in your code and in adrees bar of window. It seems that u are writin it in adressbar of the window. otherwise The first one should not work and the second one should work.

WE are writing '\\' instead of '\' while assigning the string to distigunish it from escape sequence. I.e. '\n'represents next line.

Re: Window questions [modified]

toxcct19-Sep-07 2:00

toxcct

19-Sep-07 2:00

GauranG033 wrote:
First tell me where r u using this ?? in your code and in adrees bar of window. It seems that u are writin it in adressbar of the window. otherwise The first one should not work and the second one should work.

WE are writing '\\' instead of '\' while assigning the string to distigunish it from escape sequence. I.e. '\n'represents next line.

thanks for rephrasing my answer badly Suspicious | :suss:

moreover, you have a problem in you signature[^]. please close the html tags you open, because you're breaking the site's pages style.

[VisualCalc][Binary Guide][CommDialogs] | [Forums Guidelines]

What simple API function can i use to read/create some Registry key ?

Yanshof18-Sep-07 20:29

Yanshof

18-Sep-07 20:29

I need to know which simple API function can i use to Check if some key exist in the registry and if it not exist in the registry then create it with some value that i need ( as default value ) ?

Thanks.

Re: What simple API function can i use to read/create some Registry key ?

nbugalia18-Sep-07 20:48

nbugalia

18-Sep-07 20:48

Use GetProfileString/GetProfileInt and WriteProfileString/WriteProfileInt functions for reading and writing string and integer values to retistry.

Re: What simple API function can i use to read/create some Registry key ?

Randor 18-Sep-07 20:57

Randor

18-Sep-07 20:57

if RegOpenKeyEx() returns ERROR_SUCCESS then the key exists. You should then call RegCloseKey() after successful opening.

-Randor

Grayscale color in xp

nbugalia18-Sep-07 19:54

nbugalia

18-Sep-07 19:54

I want to set the display of my xp desktop as grayscale. This means all the things will be visible in grayscale. It's same as if I were using monochrome monitor. As there is not option to set it, I m thinking to do it programmatically, but don't know where to start.

Could anyone please bounce some ideas on it ?

Thanks in advance.
NB++

Navigate function of a CWebBrowser class

AnayKulkarni18-Sep-07 19:47

AnayKulkarni

18-Sep-07 19:47

hello to all,
i want to use "Navigate" function of CWebBrowser class which i have added as an activex control in my programm, this function should get called after clicking a perticular button of a dialog box.can anybody help me plz how to do it.

Anay Kulkarni

Re: Navigate function of a CWebBrowser class

nbugalia18-Sep-07 19:58

nbugalia

18-Sep-07 19:58

CString CPPath = "http://codeproject.com";
m_Browser.Navigate( CPPath, NULL, NULL, NULL, NULL );

Re: Navigate function of a CWebBrowser class

AnayKulkarni18-Sep-07 20:06

AnayKulkarni

18-Sep-07 20:06

CString CPPath = "http://codeproject.com";
m_Browser.Navigate( CPPath, NULL, NULL, NULL, NULL );

i tried this, but it is giving me an error, i think it is asking for a pointer rather that "NULL" to a frame which we should create to display the web site, how to do it?

Anay

Re: Navigate function of a CWebBrowser class

nbugalia18-Sep-07 20:11

nbugalia

18-Sep-07 20:11

Add Microsoft Web Browser ActiveX control to the resource.
Use class wizard to add a variable to that resource.
It will ask you to add a class first. Let it do that.

The variable m_Browser is added by using class wizard and it's working fine.

Re: Navigate function of a CWebBrowser class

bhogavalli suresh18-Sep-07 23:14

bhogavalli suresh

18-Sep-07 23:14

u better go for shellExecute functon

try this

Re: Navigate function of a CWebBrowser class

AnayKulkarni19-Sep-07 0:31

AnayKulkarni

19-Sep-07 0:31

yes! it worked, thanks a lot sir.

Anay

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