|
How is your programming affected by the runtime dependencies of Excel?
Mark
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/coffee.gif)
|
|
|
|
|
Hi Mark,
I am using Visual Studio 2005 to build a COM component for Excel 2003. Since Visual Studio 2005 will utilize .Net 2.0, I suspect there are some conflict if Excel 2003 is using another version of .Net (e.g. 1.1). Any comments?
regards,
George
|
|
|
|
|
I thought COM was supposed to insulate us from that problem 
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Hi Mark,
Why do you make such conclusion? More details?
regards,
George
|
|
|
|
|
One of the fundamental reasons for COM is interoperability regardless of platform or language.
If some other app requires a certain platform it doesn't sound like COM to me.
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Thanks for your advice, Mark!
regards,
George
|
|
|
|
|
Excel 2003 is entirely native. Don't know about 2007, though.
|
|
|
|
|
Thanks Nemanja,
Do you know whether there are any support document (official)?
regards,
George
|
|
|
|
|
Get a copy of Dependency Walker[^] and then have a look at all the DLL's it pulls up. I know for sure that Excel 2003 doesn't require .Net.
¡El diablo está en mis pantalones! ¡Mire, mire!
Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)!
SELECT * FROM User WHERE Clue > 0
0 rows returned
Save an Orange - Use the VCF!
VCF Blog
|
|
|
|
|
Hi Jim,
I have installed this tool and use File --> Open to open Microsoft Excel, and on the left side, there is a tree hierarchy describing the dependencies of DLLs.
Do you know how to make conclusion of whether Excel is dependent on any .Net Runtime Framework from the output of DLL dependencies of dependency walker?
regards,
George
|
|
|
|
|
George_George wrote: How about Microsoft Excel 2007?
You have COM library to manipulate same!
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
Support CRY- Child Relief
|
|
|
|
|
Sorry ThatsAlok, could you provide more information please? Manipulate what?
regards,
George
|
|
|
|
|
Hi There,
Myself Abhijit and need some input from your side about DEVCON. I hope you will help me in this regard.
I am working on module in which USB drive needs to be ENABLED or DIABLED through command line argument ON or OFF.
Initially I achieved it by changing registry values for USBSTOR and imagepath location. But as REBOOTING of system is required, I used devcon.exe to enable or disable USB drive. I used command
Devcon disable USBSTOR\DISK* to Disable USB and devcon enable USBSTOR\DISK* to enable USB. Devcon.exe was placed in my code folder.
Now problem is I want to remove devcon dependency and use devcon's code in my application for enabling or disabling USB drive.
I am not getting which functions to used for the same and how?
Do you have any idea or sample code in this regard with you so that i can proceed further.
I am getting lot of compilations errors when I include devcon.h and use functions from devcon.cpp like enumeratedevices and so on.
Can you please help me in this regard as this is very urgent for me? I do not have any prior knowledge about devcon.
Hoping a positive reply from your side.
Best Regards,
Abhijit Kulkarni,
|
|
|
|
|
kulkarniquiet wrote: I am not getting which functions to used for the same and how?
Do you have any idea or sample code in this regard with you so that i can proceed further.
I am getting lot of compilations errors when I include devcon.h and use functions from devcon.cpp like enumeratedevices and so on.
Devcon is the sample code for showing how to do this. First, get devcon itself to compile then step through in the debugger to trace how it performs the commands you want. Once you understand all the steps that devcon goes through, then and only then start putting the required functions into your code. You really need to do the first step if you want to understand how enables and disables work. You're getting into the realm where you really need to understand what is being done and why. If you can't figure it out by looking at and stepping through devcon's source, you really shouldn't be trying to do it. I don't mean to preach (well, yes I do), but you're trying to work at a level where you've got spend the time to learn it yourself and be able to figure out for yourself what a working sample does if you hope to proceed.
Judy
|
|
|
|
|
Thanks Judy for the quick response.
I am doing exactly the same at present what you have mentioned in the reply.
Thanks again..
Abhijit
|
|
|
|
|
I apologize if I sounded harsh. I've seen too many folks start playing around with hardware and then massively mess up a system because they didn't truly understand what they were doing. I just wanted to save you from going down that road.
Also, you didn't mention what type of USB device you're looking to enable / disable. Especially if it is a mass storage device, you'll need to deal with the case where some program is accessing the storage when you want to disable it. The OS will let you disable it and then send errors to the programs. It's safe to do with respect to system integrity, but not very user-friendly.
Judy
|
|
|
|
|
Hi Judy,
I will take care of it. Thanks for information.
I am dealing with mass storage device.
I will get back to you with the updates once I finished the same.
Abhijit
|
|
|
|
|
Hi
I want to ask a question which is very important for me.
My project is on Windows CE but the problem is about visual C++.I have a worker thread that is waiting for the data coming from serial port.I want that when a definite data is comes I want to change the focus on controls.I am doing that with;
if(the definite data comes)<br />
dlg->PostMessage(WM_NEXTDLGCTL,NULL,NULL);
dlg is the object of the dialog box which I want to change the focus.But that is working only for the dialog box which the thread is working in.I cannot change the focus of controls for dialog boxes other then the dialog box which has the thread.
If I can explain the problem can you help me.
Thanks
|
|
|
|
|
Two considerations:
1. Only one window can have the focus at a time.
2. It is indeed possible to give the focus to a dialog which is not used to start a thread. This a design problem.
Post the code where :
a. you create the thread
b. you want the dlg to be updated.
|
|
|
|
|
iayd wrote: I want that when a definite data is comes I want to change the focus on controls.
So why are you not calling SetFocus() for the control you want to have focus?
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
Are you really passing NULL for the WPARAM/LPARAM parameters when posting the WM_NEXTDLGCTL message?
That sets the focus to the next control in the dialog that has the WS_TABSTOP style. Is that what you want or
do you want the focus on a certain control?
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Another Filet-O-Fish multi-threading *sigh*
|
|
|
|
|
Yeah. I figured filet-o-fish threading would fix this one[^]
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Man you two are priceless! I've got tears rolling down my face I'm laughing so hard!
Have you guys considered starting your own show?
¡El diablo está en mis pantalones! ¡Mire, mire!
Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)!
SELECT * FROM User WHERE Clue > 0
0 rows returned
Save an Orange - Use the VCF!
VCF Blog
|
|
|
|
|
I don't know about led mike, but I find laughing through the pain to be good therapy.
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
