|
It can be done using Excel as a COM object, although obviously you need Excel installed to do it.
I don't recall the details, but I know they came from a CUJ or WDJ article.
Christian
As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.
Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.
|
|
|
|
|
Woo, it's not too difficult to manipulate Excel programmatically, believe me 
I've just written a prototype for two-days, and I never "touch" on Excel before, but my application seemed work-well 
Tips: Use VB6 for explore the object model of Excel (and any Office applications), read "Office 2000 Developer's Guide" in MSDN, and the last,
#import "Excel.exe" and GO!!!
good luck,
|
|
|
|
|
|
It's time for the experts to help out.
I have a situation where I need to guarantee that an object is created and deleted from the same point. Better said that if it is "new'd" in a DLL, the delete must happen there too. [the linkage of the new and delete must be from the same source]
Or created in the EXE and deleted there.
The twist of this -- is that these objects are being created, and then fed into a machine object, which will dispose them when done. After I create this object, and feed it to the machine, then I am done with it. The machine object will use it, and dispose of it when done.
So, here's an example:
class BaseObject
{
public:
virtual void DeleteThis() = 0;
virtual void DoSomething() = 0;
};
class MyClass : public BaseObject
{
static New();
MyClass();
virtual void DeleteThis();
virtual void DoSomething();
};
MyClass *MyClass::New()
{
return new MyClass();
}
MyClass::MyClass()
{
}
void MyClass::DeleteThis()
{
delete this;
}
void MyClass::DoSomething()
{
printf( "%s", "I did it" );
}
/// some code
...
MyClass pObj = MyClass::New();
pObj->DoSomething();
pObj->DeleteThis();
...
this works -- but the question of safety has come up -- and this sample forces the linkage of new and delete to reside in the same .OBJ file (does this make sense?).
Is "delete this" safe in this situation?
|
|
|
|
|
this works -- but the question of safety has come up
AFAIK this is safe. It's OK to perform 'delete this'. Of course, you shouldn't access object after deleting.
this sample forces the linkage of new and delete to reside in the same .OBJ file
I believe new and delete do not reside in .obj file - they come from static/dynamic C++ runtime .lib.
Tomasz Sowinski -- http://www.shooltz.com
|
|
|
|
|
This is also the way the MS teachs reference counting support in COM objects.
<br />
void IClass::Release()<br />
{<br />
if ( --m_RefCount == 0 )<br />
{<br />
delete this;<br />
}<br />
}<br />
so, doing this, is fine to. It does look strange...
<br />
void IClass::DeleteThis()<br />
{<br />
delete this;<br />
}<br />
|
|
|
|
|
|
I am currently confused as to which control I should be using in my dialog.
The control is to display information as steps are completed. I want it to have the following capabilities.
1. Output only.
2. Multiple lines.
3. Add lines one at a time.
4. Handle different fonts.
CEdit - 1, 2 and 4
CStatic - 1 and 2
Am I missing something? Can one of these controls do all I want? Or is there another control that can do whatI want?
Michael Martin
Pegasystems Pty Ltd
Australia
martm@pegasystems.com
+61 413-004-018
"Don't belong. Never join. Think for yourself. Peace"
- Victor Stone
|
|
|
|
|
I do that with our console in Win32 like this:
::SetFocus (editControl);
::SendMessage (editControl, EM_SETSEL, (WPARAM)length, (LPARAM)length);
::SendMessage (editControl, EM_REPLACESEL, 0, (LPARAM) ((LPSTR) str.c_str()));
::SendMessage(editControl, EM_LINESCROLL, 0, (SendMessage(editControl, EM_GETLINECOUNT, 0, 0)));
Essentially I select the caret position at the end, and replace it with the text I want to append, thus adding a line. I also catch the message that tells me the edit is full and trim from the top to make room at the bottom, but I've not shown that. The last line scrolls the edit box down to the line I just added.
Christian
As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.
Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.
|
|
|
|
|
If you need (4), you'll have to abandon CEdit and CStatic. I think you should use CRichEditCtrl or custom-draw CListCtrl.
Tomasz Sowinski -- http://www.shooltz.com
|
|
|
|
|
I want get the data of cell(X,X) from a Excel document ,how to implement the COM object?
Please pardon my weak English!
|
|
|
|
|
|
Thanks a lot,I got it!
Please pardon my weak English!
|
|
|
|
|
This is a great article located here:
http://www.codeproject.com/combobox/customcombo.asp
Its a CListBox. Can someone, anyone help me make it variable row height? Some of my text is really short, just one (1) line? Some of my text is really long, 3-6 lines. How can I make it variable row height?
Please, please, please, any response any one can give me will be greatly appreciated.
Sincerely,
Danielle (an overworked graduate student)
|
|
|
|
|
Will this do?
http://www.codeproject.com/useritems/changerowheight.asp
|
|
|
|
|
|
Anyone know how I could set the Zorder of my window or how i would go about setting an application or window behind the desktop icons?
Any ideas, theories or opinions would be great,
Ryan
|
|
|
|
|
Hello, the codegurus around the world.;)
I'm curious why you need this kind of capability in your application?
Have a nice day!
-Masaaki Onishi-
|
|
|
|
|
im going to make a custom desktop for myself. And was just wondering if their was away to get the desktop icons to still show. Its not a big deal I will probably just make it go full screen over my desktop.
Pretty much going to make something like Stardocs ObjectX or DesktopX
|
|
|
|
|
No, for two reasons. 1) The desktop window is the parent of all top-level windows, and 2) The desktop is a list control - the icons aren't on their own plane in the Z order.
--Mike--
http://home.inreach.com/mdunn/
"The Earth is doomed." -- Rupert Giles
![Heart | [heart]](https://www.codeproject.com/script/Forums/Images/love.gif) your ![Green Alien | [Alien]](https://www.codeproject.com/script/Forums/Images/alien.gif) with ![Good Stuff | [The good stuff]](https://www.codeproject.com/script/Forums/Images/vegemite.gif) and ![Beer | [beer]](https://www.codeproject.com/script/Forums/Images/beer.gif)
|
|
|
|
|
Hi,
I just installed the latest Platform SDK, aug 2001 release. I've integrated it in Visual C++ 6.0 by adding the SDK include and lib directories before the old ones, like the documentation says. But i still can compile code using the UpdateLayeredWindow function it still give an error C2065 "UpdateLayeredWindow" : undeclared identifier.
What is wrong ? Any clues ?
Best regards.
Johan Janssens
JJanssens@mail.ru
|
|
|
|
|
That's a Win2000 function ? Have you set WinVer properly ? If you don't do the #defines to say you're compiling for Windows 2000, it's probably being #ifdef'd out.
Christian
As I learn the innermost secrets of the around me, they reward me in many ways to keep quiet.
Men with pierced ears are better prepared for marriage. They've experienced pain and bought Jewellery.
|
|
|
|
|
|
A comment on the part of the FAQ addressing the SDK Update vs. full download via FTP: It's possible to download the full SDK from the ms site. At http://www.microsoft.com/msdownload/platformsdk/sdkupdate/ you just click "Full Download" in the menu band. The rest is trivial.
Cheers
Steen.
"To claim that computer games influence children is rediculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music"
|
|
|
|
|
Thanks, Steen. MS must've added that full download link recently; it wasn't there when I first went to the SDK Update site.
--Mike--
http://home.inreach.com/mdunn/
"The Earth is doomed." -- Rupert Giles
your with and
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
