C / C++ / MFC Discussion Boards

MsmVc5-Oct-09 20:57

5-Oct-09 20:57

Hi All

I am getting excel rows and columns through this way.

Excel::RangePtr pRange = sheet1->UsedRange;
if ( pRange == NULL )
{
	return 0;
}
VARIANT var=pRange->GetValue();
if(var.vt==VT_EMPTY)
{
return true;
}
long row;
long col;
COleSafeArray sarect(pRange->GetValue());
sarect.GetUBound(1,&row);
sarect.GetUBound(2,&col);

it's working well but i have found some specific case error.Like when excel sheet content only one cell value then showing debug assertion failed.

File:f:\dd\vctools\vc7libs\ship\atlmfc\src\mfc\olevar.cpp
Line:1817

COleSafeArray& COleSafeArray::operator=(const VARIANT& varSrc)
{
	ASSERT(varSrc.vt & VT_ARRAY);

	if(!(varSrc.vt & VT_ARRAY))
		AfxThrowInvalidArgException();		

	AfxCheckError(::VariantCopy(this, (LPVARIANT)&varSrc));
	return *this;
}

Plz help me.

Getting function result from Sheetcalculate event of Excel::WorkbookEvents

NarVish5-Oct-09 19:27

NarVish

5-Oct-09 19:27

Hi,
SheetCalculate function is getting fired whenever there is change in function(like =sum(A1,A2)) related Excel workbook cells. My aim is to get the function result in excel. To get that I'm trying by calling different functions of iDispatch. But couldn't able to get the expected result. Please guide me to read the function result. Thanks in advance.

_ATL_FUNC_INFO SheetCalculateInfo = { CC_CDECL, VT_EMPTY, 1, { VT_DISPATCH } };
BEGIN_SINK_MAP(ExcelBookEventHandler)
SINK_ENTRY_INFO(1, __uuidof(Excel::WorkbookEvents), 0x0000061b, &ExcelBookEventHandler::SheetCalculate, &SheetCalculateInfo)
END_SINK_MAP()
void _stdcall SheetCalculate(IDispatch *iDispatch)
{
////////////*******GetIDsOfNames*******////////////
static DISPID dispid = 0;
wchar_t *ucName = L"Evaluate"; //I tried by giving "Run" and "Calculate" values in place of "Evaluate"
HRESULT result = iDispatch->GetIDsOfNames(IID_NULL, &ucName, 1,LOCALE_SYSTEM_DEFAULT, &dispid);

////////////*******Invoke*******////////////
VARIANT varResult;
DISPID dispid;
DISPID dispidNamed = DISPATCH_METHOD;
EXCEPINFO excep;
UINT uArgErr;
DISPPARAMS dispparams;
dispparams.cNamedArgs = 0;
dispparams.cArgs = 2;
dispparams.rgdispidNamedArgs = &dispidNamed;
HRESULT result = iDispatch->Invoke( odispid, IID_NULL, LOCALE_SYSTEM_DEFAULT,
DISPATCH_METHOD, &dispparams, &varResult, &excep, &uArgErr);

////////////*******GetTypeInfo*******////////////
ITypeInfo* pTypeInfo;
HRESULT result= iDispatch->GetTypeInfo(0,LOCALE_SYSTEM_DEFAULT,&pTypeInfo);

////////////*******GetTypeInfoCount*******////////////
UINT pct1;
HRESULT result= iDispatch->GetTypeInfoCount(&pct1);

////////////*******QueryInterface*******////////////
HRESULT result = iDispatch->QueryInterface(IID_IDispatch,(void**)&iDispatch);
}

Save Folder path

Game-point5-Oct-09 18:36

Game-point

5-Oct-09 18:36

hi

i have little bit problem in how to get folder path ??

UpdateData();
	CFile __file;
	CFileDialog __FileDialog(true,"*.*",NULL,OFN_EXPLORER,"All Files : (*.*)|*.*||");
	//CFileDialog __FileDialog(TRUE, _T (".xyz"), 0, 4 | 2, _T ("XYZ Files(*.xyz)|*.xyz All Files(*.*)|*.*||"), this, 0, 0); 
	if (__FileDialog.DoModal() == IDOK)
	{
		if( __file.Open(__FileDialog.GetFileName(), CFile::modeRead) == FALSE )
			return;
		<big>CArchive ar(&__file, CArchive::load);</big>		
	}
	__file.Close();
	UpdateData(true);

here output is : D:\2009\October\Visual Studio Projects\visual\centerI.TIF

but i need save this file path :
D:\2009\October\Visual Studio Projects\visual\

please how to get folder path ?

Thanks

Re: Save Folder path

Naveen5-Oct-09 19:03

Naveen

5-Oct-09 19:03

raju_Code wrote:
please how to get folder path ?

__FileDialog.GetFolderPath()

nave

[OpenedFileFinder] [My Blog]

Re: Save Folder path

Game-point5-Oct-09 19:11

Game-point

5-Oct-09 19:11

Thanks for your response Mr.Naveen

its throwing exception ..

when comes __FileDialog.DoModel()

its open's system dialog its having Open and Cancel button

i need Save and Cancel button //

Thanks

Re: Save Folder path

Naveen5-Oct-09 19:14

Naveen

5-Oct-09 19:14

raju_Code wrote:
i need Save and Cancel button //

Read some documentation[^]

nave

[OpenedFileFinder] [My Blog]

Re: Save Folder path

Game-point5-Oct-09 19:25

Game-point

5-Oct-09 19:25

i think its not possible na?

Re: Save Folder path

Naveen5-Oct-09 20:06

Naveen

5-Oct-09 20:06

Pass the first parameter to the CFileDialog constructor as "FALSE". Then you will get "save as" dialog.

nave

[OpenedFileFinder] [My Blog]

Re: Save Folder path

Game-point5-Oct-09 20:24

Game-point

5-Oct-09 20:24

Thanks naveen ..

i finished from SHBrowseForFolder APIs ..

now its working

Thanks for your proper response

Re: Save Folder path

David Crow6-Oct-09 3:14

David Crow

6-Oct-09 3:14

raju_Code wrote:
i need Save and Cancel button //

You need them for what?

"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

Re: Save Folder path

S p k 5215-Oct-09 22:49

S p k 521

5-Oct-09 22:49

Hi,

You can make use of _splitpath() after getting the complete path to the file.

Regards,
Suku PK

Re: Save Folder path

David Crow6-Oct-09 3:13

David Crow

6-Oct-09 3:13

raju_Code wrote:

here output is : D:\2009\October\Visual Studio Projects\visual\centerI.TIF

but i need save this file path :
D:\2009\October\Visual Studio Projects\visual\

please how to get folder path ?

Use PathRemoveFileSpec().

Harmful USB Devices

NetDefender 20095-Oct-09 8:21

NetDefender 2009

5-Oct-09 8:21

how can I write a code for scanning harmful USB devices in a good programming language and with a good GUI.I have a database for the viruses
so when the USB device is connected the software will look up for in the list and if there is a virus tehn it will prompt the user.

Re: Harmful USB Devices

David Crow5-Oct-09 8:24

David Crow

5-Oct-09 8:24

Scanning USB devices is easy enough. How would your code know whether they were harmful?

How to create a program for querying active directory using visual C++

raja 45-Oct-09 4:55

raja 4

5-Oct-09 4:55

Dear Expert,

How to create visual c++ project using ADSI

Re: How to create a program for querying active directory using visual C++

CPallini5-Oct-09 6:57

CPallini

5-Oct-09 6:57

What about documentation [^]?
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

convert CString to double

soongez5-Oct-09 4:46

soongez

5-Oct-09 4:46

Hey, I know this has been asked many times, and I've researched several solutions like atod etc,

here are some bits from my code.

CString line;
chkfile.ReadString(line)
CString token;
token = line.Tokenize(_T(" "),v);
TRACE(L"token %s\n",token);
TRACE(L"converted %d\n",_tstof(token));

chkfile is a CStdioFile.

the TRACE reads something like

token 66
converted 0

Why is always returning error code 0?

Thanks
soong

Re: convert CString to double

Code-o-mat5-Oct-09 5:11

Code-o-mat

5-Oct-09 5:11

soongez wrote:
TRACE(L"converted %d\n",_tstof(token));

%d expects an integer type
_tstof returns a double

Try with %f or %g or somesuch instead of %d.

> The problem with computers is that they do what you tell them to do and not what you want them to do. <
> Sometimes you just have to hate coding to do it well. <

Re: convert CString to double

Cedric Moonen5-Oct-09 7:50

Cedric Moonen

5-Oct-09 7:50

soongez wrote:
TRACE(L"converted %d\n",_tstof(token));

Wait, so you already have your double in a string but you first want to convert to a float and then back to a string... Why don't use the string directly ?

Cédric Moonen
Software developer

Charting control [v2.0]
OpenGL game tutorial in C++

Re: convert CString to double

soongez5-Oct-09 16:27

soongez

5-Oct-09 16:27

Thanks the %f worked, but I used _tstof because the other double converters would give me errors such as cannot convert CString to char* because 'line' was a CString and I couldn't change it to char* when using ReadLine. I'm still pretty poor in using pointers etc.

The TRACE is just to test if the output is correct, it will be used somewhere else later in the program.

cheers.

Change Background image of mesage box

Pryabu5-Oct-09 2:31

Pryabu

5-Oct-09 2:31

Hi all,

I have created a dialog box with blue background color. i want to change the background color of message box too in that dialog.How to add background image to a message box?

Thanks,

Re: Change Background image of mesage box

CPallini5-Oct-09 2:42

CPallini

5-Oct-09 2:42

AFAIK you cannot do that with standartd message boxes: you've to roll your own version of.
Smile | :)