|
Currently my the process I'm going through for each change of the C# code in the COM object is the following. Is there anyway I can streamline the number of manual steps involved?
Close the Excel spreadsheet using the COM object.
Build the COM object using VS03.
Open the spread sheet.
Open VBA.
Open the references dialog.
Remove the Missing:myObject reference.
Close the references dialog.
Reopen the references dialog.
Add the MyObject reference.
Close the references dialog.
Run the VBA.
Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop.
-- Matthew Faithfull
|
|
|
|
|
Aside from writing log files or spitting out mesageboxes can I debug a managed COM (C#) object being called from within a VBA (excel) application?
Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop.
-- Matthew Faithfull
|
|
|
|
|
I've found I can open my test spreadsheet automatically when i start my VS project using the debug properties page of the project. I've found a new showstopper though. The moment I try and run the calling VBA macro in my spreadsheet it closes excel and ends my VS debugging session. The same thing happens if I have it launch excel without a document and then manual open it using that copy of excel.
If I open the spreadsheet in a separate excel window the macro runs and calls the COM object successfully but my breakpoints in the C# code are ignored.
Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop.
-- Matthew Faithfull
|
|
|
|
|
Does VS03 need to write the registry every time a COM object is recompiled, or only the first time?
Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop.
-- Matthew Faithfull
|
|
|
|
|
Check Post-Build event in your Project properties
Sohail
modified 21-Apr-21 21:01pm.
|
|
|
|
|
THe post build event is empty. The registry fiddling is apparently being done elsewhere.
Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop.
-- Matthew Faithfull
|
|
|
|
|
Do you build your project from within Visual Studio IDE or through any custom script (e.g batch script etc) ?
Sohail
modified 21-Apr-21 21:01pm.
|
|
|
|
|
VS IDE. Project type is: Other projects-extensibility projects-shared add in
Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop.
-- Matthew Faithfull
|
|
|
|
|
I tried creating a sample Project type : Other projects-extensibility projects-shared add in
By default, Post build event has -
regsvr32 /s /c "$(TargetPath)"
This will register adding every time you build. This is just a development time helper.
Sohail
modified 21-Apr-21 21:01pm.
|
|
|
|
|
I have added a new interface to my activex control (ACEvt)
I have modified the odl file, and added the necessary BEGIN_INTERFACE_MAP, BEGIN_DISPATCH_MAP etc.... in the class implementation file.
//odl file
[ uuid(BED02315-567E-4a5d-A56B-5F00F228E041)]
dispinterface ICount
{
properties:
methods:
};
[ uuid(7C39BF1F-66DE-423e-B526-87626D80AE4D)]
coclass Count
{
[default] dispinterface ICount;
};
When I try to call CoCreateInstance and QueryInterface, i'm getting E_NOINTERFACE error.
IUnknown *pUnk = NULL;
HRESULT hr = CoCreateInstance(CLSID_ACEvt,NULL,CLSCTX_ALL,IID_IUnknown,(void **)&pUnk);
ICount *pCount = NULL;
hr = pEvt->QueryInterface(DIID_ICount,(void **)&pCount);
When I tried directly calling CoCreateInstance on Count, then I got "Class not registered error"
HRESULT hr = CoCreateInstance(CLSID_Count,NULL,CLSCTX_ALL,DIID_ICount,(void **)&pCount);
What might be the problem?
Thanks
|
|
|
|
|
Increment major version number on your type library.
|
|
|
|
|
Can anybody suggest me the material or site to refer to study ActiveX, ATL and COM control since i m new to this concept...
werwr
|
|
|
|
|
I'm passing an HBITMAP between an application and an out-of-process server.
If the HBITMAP is from a device compatible bitmap, the application displays it correctly.
If the HBITMAP is a DIB section, it displays as a black rectangle the same size as the bitmap.
Any ideas?
Software Zen: delete this;
|
|
|
|
|
I am developing a COM exe using ATL in VS 2005.
On my build machine( XP Pro) , I am able to successfully run the application (debug version )however when I copy the exe to another machine (XP Pro) the exe cannot run .
I get an error message
"The application has failed to start because the application configuration is incorrect . Reinstalling the application may fix this problem"
I have no clue about this error .
Help is appreciated !
|
|
|
|
|
First thing, you cannot distribute debug version of your program.
Then, you need to install the run-time libraries and MFC libraries on the target machine. For that, you can execute vcredist_x86.exe on the target machine (you can download it from here[^]).
The link I provided is for VC2005 standard. If you installed the SP1 for VC2005, then look at the links at the bottom of the page, there is a similar download for SP1.
This will install the release versions of the libraries, so you need to distribute a release version of your program too.
|
|
|
|
|
I've taken source code from several samples on the web, created a new class library project, and compiled it but I'm only getting a .dll file output, not the .tlb file regasm needs.
Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop.
-- Matthew Faithfull
|
|
|
|
|
REGASM[^] has an option to generate TLB file
Sohail
modified 21-Apr-21 21:01pm.
|
|
|
|
|
I have an Activex control which exposes multiple interfaces for example,
ISample1 – CSample1 (Coclass)
ISample2 – CSample2 (Coclass)
I need to add new methods/properties (a new version). Since ISample1 and ISample2 cannot be modified, I’ll have two new interfaces,
ISample1Ext
ISample2Ext
These will be a replication of ISample1 and ISample2, but with new methods/properties added. The old interfaces will be marked deprecated and may be removed in future.
The question is, can I still use the classes CSample1 and CSample2 as CoClasses for ISample1Ext and ISample2Ext and modify them to implement the new methods/properties?
If this new version of the control is copied to the client m/c, how will it affect the applications that are using the old version of the control?
If I try to insert this control in an application, which version will be inserted? Also, how do you differentiate between the old version and the new version?
Thanks
|
|
|
|
|
Dear all,
we can invoke our dlls from backgroud services.. like from "services.msc",
i have adoubt when we are writing such services what should be taken care so that it comes under "services.msc" not in "dcomcnfg"
and what is the difference in those two types ....
Thanks in advance
T@SU
|
|
|
|
|
Hello,
I have a problem with calling my COM server. It connects and runs successfully with my development box, but crashes on another box.
On the other box, a CoCreateInstance call like:
CComPtr<imyclass> p;
hr = CoCreateInstance(CLSID_MyClass, NULL, CLSCTX_ALL, IID_IMyClass, reinterpret_cast<void**>(&p));
succeeds. Also calls to e.g. p->QueryInterface are ok. But if I call my own methods, it crashes with an access violation / null pointer. The problem is, that I cannot see, where the null pointer is. I don't know, which information I should provide, in order to help someone help me, so please ask anything.
Code is plain C++ with no .NET. Dev Box is a Win XP system, other box a Windows Server 2003 SP2.
To explain a bit more: The null pointer seems to be inside of the com call, since when I debug both client and server, the breakpoint inside of the server is not reached. The error message I get is "Unhandled exception at 0x00000000 in bin.exe: 0xC0000005: Access violation reading location 0x00000000." when I call p->Init(CComBstr, int) (The string is allocated correctly).
I'm pretty confused and don't even know where to start looking. Searching with something like "atl com access violation" or similar doesn't help.
Thanks in advance!
|
|
|
|
|
Solved:
The client was not linked with the server.LIB from the server. The .LIB was in the same directory, when the client was launched on my development box, but I've only used the EXEs on the 2003 OS. Linked the client with the LIB and everything workes fine.
|
|
|
|
|
hello,
I opened the excel file by using workbook.open() method...
Now i want to read the data from the excel file.. & save it into
array.
help out .. how to do this.
Then i want to pass that array through SetSourceData() method & want to draw cunztomized chart...
(I am using Excel 2007, C# 2005, COM)
Thx... 
|
|
|
|
|
Hello Masters!
I am using VC.NET 2003.
In my project i want to use a xyz.dll which was written in VB 6.0.
In my VC.NET Project i use the code as shown below.
<br />
<br />
#import "MyTapi.dll"<br />
<br />
HRESULT hr;<br />
MyTapi::_Class1Ptr IPtr;<br />
hr=IPtr.CreateInstance(__uuidof(MyTapi::_Class1));<br />
<br />
The dll MyTapi.dll i've copied it in the current working folder as well in system32 and i've registered MyTapi.dll using regsvr32 on command prompt it registeres successfully.
But in the code above hr=Class Not Registered when I wan't to create intereface pointer of _Class1 
Thanks in Advance.
ritz123
|
|
|
|
|
Hello,
(for all of the followNg i m usNg C#2005, Excel 2007 & have to through COM)
i tried to open existNg Excel file by using follow method bt it gives error ... that this file doesnt exist or path is incorrect........
wb = ThisApplication.Workbooks.Open(paramWorkbookPath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
& i also used this method tooo..
it also doesnt work .. 
wb= ThisApplication.Workbooks.Open(paramWorkbookPath, 0, true, 5,
"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,
0, true,Type.Missing, Type.Missing);
//////////
second thing how to read data from excel file & use it for charts...
can any give example
i am using Excel 2007 , C# 2005 ... all z doing using COM...
waiting for reply..
thanks...........
|
|
|
|
|
Hi everybody!!
I've done some research on the msdn about the WebBrowser control, but yet I can't find what it is. I can see the properties, events and so on, and by the way it's used i think it might be an ActiveX, but I'm not sure.
So can anybody tell me if it's actually an ActiveX, and if gets registered when Windows is installed? Also, is it used by IntenetExplorer in any of its features?
Please, if someone can help me out by explaining this to me or giving me a link to a page where all of these is explained, I will really appreciate it.
Thanks
Kenia
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
