|
Do we have an pre-requistes before creating an excel object for a windows application developed using c#?
Is there any sort of memory limitation when creating an excel object. Our application runs fine when few processes are running along with the application, however when the number of other processes are increased then an error is displayed " <b>THERE IS NOT ENOUGH MEMORY TO RUN MICROSOFT EXCEL. PLEASE CLOSE OTHER APPLICATION AND TRY AGAIN </b>". The solution to this error is a system restart, when this error occurs you cannot open any existing excel file too!
Please note that our application has needed excel objects clean up code.
What could be the cause for this error? How to resolve this?
Kindly help!
gauthee
|
|
|
|
|
|
Hi,
I am programming a COM object in C++, to be used in a Visual Basic Apllication.
I want to know if there is a way to separate the interface members with namespaces like this
Study.FramesOfReference.Series.Item()
where Study is a COM Object that contains a CoClass FramesOfReference which Contains a CoClass Series wich has a method Item()
Thank U very Much
JO
|
|
|
|
|
Ju@ncho wrote: I am programming a COM object in C++, to be used in a Visual Basic Apllication.
I want to know if there is a way to separate the interface members with namespaces like this
Study.FramesOfReference.Series.Item()
where Study is a COM Object that contains a CoClass FramesOfReference which Contains a CoClass Series wich has a method Item()
Thank U very Much
I wonder if you have your terminology right. A COM object can reasonably contain another COM object, but not a CoClass. Also, a method of a CoClass would be equivalent to a C++ static method, which I don't think COM supports either. Also neither containment of objects or CoClasses is considered a namespace.
If you are using VB.NET, there is probably a way to import COM objects into specific namespaces, even though COM doesn't really support namespaces. In both VB.NET and VB6, a COM object Study can have a property FrameOfReference, which is an object that has a property named Series, which is an object with an Item method. Is this what you were trying to say?
Nathan
|
|
|
|
|
When i said Coclass i was trying to say a COM Object or a C++ Object, so what i want to do, like you say is:
having a property Frame of Reference which is an Object that has a property named Series named Series Which is an Object with an Item Methhod , the diffulty arises when i try to use properties which are objects. Especially with IDL.
Do you know if i can use C++ objects as properties in ATL or i have to use COM objects, in that case which parameters i Have to use in the definition of the property in mi idl file?
Thank you very much
JO
|
|
|
|
|
Ju@ncho wrote: Do you know if i can use C++ objects as properties in ATL or i have to use COM objects, in that case which parameters i Have to use in the definition of the property in mi idl file?
COM objects would definitely be more apropriate. They only need to have CoClasses if you need a client to be able to create instances of them directly. Within your own code, you can create an object without a CoClass using CComObject<yourclass>::CreateInstance()</yourclass>
It is possible to use plain structures if you don't need to fully support automation. (Visual Basic can handle structures though.) You need to define your structures in the idl file, and you should give each structure type its own guid.
Nathan
|
|
|
|
|
Hello Ju@ncho,
There are two ways you can achieve your design :
1. By declaring the object properties "FramesOfReference" and "Series" as of their individual interface types (e.g. IFramesOfReference, ISeries, respectively) :
interface IStudy : IDispatch
{
[propget, id(1), helpstring("property FramesOfReference")]
HRESULT FramesOfReference([out, retval] IFramesOfReference** pVal);
[propput, id(1), helpstring("property FramesOfReference")]
HRESULT FramesOfReference([in] IFramesOfReference* newVal);
}
interface IFramesOfReference : IDispatch
{
[propget, id(1), helpstring("property Series")]
HRESULT Series([out, retval] ISeries** pVal);
[propput, id(1), helpstring("property Series")]
HRESULT Series([in] ISeries* newVal);
}
2. By delaring the object properties as of type VARIANT :
interface IStudy : IDispatch
{
[propget, id(1), helpstring("property FramesOfReference")]
HRESULT FramesOfReference([out, retval] VARIANT *pVal);
[propput, id(1), helpstring("property FramesOfReference")]
HRESULT FramesOfReference([in] VARIANT newVal);
};
interface IFramesOfReference : IDispatch
{
[propget, id(1), helpstring("property Series")]
HRESULT Series([out, retval] VARIANT *pVal);
[propput, id(1), helpstring("property Series")]
HRESULT Series([in] VARIANT newVal);
};
I have written a set of sample codes. Email me :
bio_lim_2004@yahoo.com
and I will send it to you.
Best Regards,
- Bio.
|
|
|
|
|
Quit posting the same question but with different termnology. Seen the same post in the ATL forum. But asking for ATL namespace.
|
|
|
|
|
Hey guyz,
Can somebody give me a simple COM+ example based on Client-Server type?
I tried to find on the net but couldnt find any.. A simple program would do too..
Thanks.
------------------------------------------------------------------
Life would have been much easier if I had the source-code!!
|
|
|
|
|
Swader wrote: Can somebody give me a simple COM+ example based on Client-Server type?
I tried to find on the net but couldnt find any.. A simple program would do too..
What features of COM+ as opposed to plain COM do you want an example of? You might get results searching for examples of the features.
Nathan
|
|
|
|
|
Hi,
We have a windows application developed using c#. We have a process in this application where excel objects are created some data is populated and some calcualtions are done too (used various excel objects like workbook, sheet, range). The required tasks are being executed fine but there are instances where the same tasks fail. An error is being thrown at that time and it is "THERE IS NOT ENOUGH MEMORY TO RUN MICROSOFT EXCEL. PLEASE CLOSE OTHER APPLICATION AND TRY AGAIN" The error is pointed to Excel object creation and it shows - "An unhandled exception of type System.Runtime.InteropServices.COMException occurred in application_name.exe"
What could be the cause for the error? Please provide some suggestions.
Thanks
gauthee
|
|
|
|
|
gauthee wrote: "THERE IS NOT ENOUGH MEMORY TO RUN MICROSOFT EXCEL. PLEASE CLOSE OTHER APPLICATION AND TRY AGAIN"
Sohail
modified 21-Apr-21 21:01pm.
|
|
|
|
|
Hello all,
How to automate Excel 2007 with C# 2003....
As i tried to automate Excel 2007 exitsing project (which is implemented in C# 2003 & used Excel2003) ............
When i did .... it genrate errors...
Microsoft.Office.Interop.Excel.Chart' is defined in multiple places;
I am unable to understand this error ...
plz help me out...
THX
|
|
|
|
|
I've created a COM library that serves as a control/object spy, from which i would like to make calls from a vbscript.
Here's a snippet of the vbscript:
<br />
Set o = CreateObject(myBot.Windows)<br />
<br />
Path = "c:\test.exe"<br />
WndTitle = "TestApp"<br />
<br />
Parent = o.Run( Path, WndTitle )<br />
If Parent Then<br />
WScript.Echo "We've successfully Launched " & WndTitle & "!"<br />
<br />
res = o.ClickButton( Parent, "Button1", "WindowsForms10.BUTTON.app.0.378734a" )<br />
<br />
'.... and so on<br />
<br />
Else<br />
'... and so on<br />
End If<br />
Here's the thing,
The vbscript is able to run the first function "o.Run(...)", but when i try executing the next function "o.ClickButton(...)", I get a "Windows Script Host" error message saying "Class doesn't support Automation: 'ClickButton'.
I've removed all instances of the dll (com library) from the 'global assembly cache' using gacutil, and un-registered it using 'regsvscs /unregister'
Does anyone have a good idea of where I could begin to resolve this issue...?
|
|
|
|
|
Does your Library support automation? I mean, how ClickButton method is declared?
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.
|
|
|
|
|
In code it's:
<br />
Public Function ClickButton(ByVal hWndParent As IntPtr, _<br />
ByVal strCaption As String, _<br />
ByVal strClass As String) As Int32<br />
<br />
Dim newWnd As IntPtr<br />
Dim ctrlID As Int32<br />
<br />
<br />
ctrlID = myBot.GetObjectHandleA(hWndParent, strClass, strCaption)<br />
If ctrlID Then<br />
newWnd = myBot.SendMessage(ctrlID, BM_CLICK, 0, 0)<br />
End If<br />
<br />
If newWnd Then<br />
Return newWnd<br />
Else<br />
Return 0<br />
End If<br />
<br />
End Function<br />
<br />
let me know...
|
|
|
|
|
IntPtr is not an Automation-compatible type. You'll have to define two versions of the interface, one for 32-bit systems and one for 64-bit, using an Integer or a Long as appropriate.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Thanks, t'was a slight oversight on my part...
I've changed the variable declarations and it works now...
Again, Many thanks!
|
|
|
|
|
hello, have some troubles getting some code working.
if you can have a look.
I have the code below, and it does insert only 2 menu items:
"Check Out" and "Delete File".
More than this at "::InvokeCommand(LPCMINVOKECOMMANDINFO pCmdInfo)"
how do I make the difference between what menu item was clicked ?
thanks
::QueryContextMenu( HMENU hmenu, UINT uMenuIndex, UINT uidFirstCmd,
UINT uidLastCmd, UINT uFlags )
{
const int size = 4;
const char* menuLabels[size] ={
"Check Out",
"Check In",
"Download",
"Delete File"
};
int menuItemPosition = uMenuIndex;
UINT menuItemID = uidFirstCmd;
for(int i=0; i<size; i++)
{
MENUITEMINFO menuItemInfo;
memset( &menuItemInfo, 0, sizeof(MENUITEMINFO) );
menuItemInfo.cbSize = sizeof(MENUITEMINFO);
menuItemInfo.fMask = MIIM_DATA | MIIM_TYPE | MIIM_ID;
menuItemInfo.fType = MFT_STRING;
menuItemInfo.wID = menuItemID++;
menuItemInfo.dwItemData = menuItemID - 1;
menuItemInfo.dwTypeData = (LPSTR)menuLabels[i];
menuItemInfo.cch = strlen(menuLabels[i]);
InsertMenuItem( hmenu, menuItemPosition++, TRUE, &menuItemInfo );
}
modified on Friday, December 14, 2007 2:37:29 AM
|
|
|
|
|
Hi everybody!!
I'm developing a web application that has embedded an activeX control. For some specific purposes I need the activeX to access the DOM elements of the page that contains it, but I don't know if this is possible. So, I need to now: first if this can be done and if so, how I could do it.
Any help or ideas will be appreciated.
Thanks
Kenia
Kenia
|
|
|
|
|
yes its possible, get IHTMLDocument2 pointer/object and you can access the element info, using several Interfaces provided by IE. look in MSDN for IHTML** interfaces...
Cheers,
Vishal
|
|
|
|
|
Thanks Vishal for your quick reply, I hope your ideas help me doing the task.
Cheers
Kenia
|
|
|
|
|
Hi All,
I am working on a project that uses interop.word COM object. But I am not able to get width and style of page border of document. Can I know how I'll get these values?
Thanks in advance,
Priyank
|
|
|
|
|
Hi
I am reading this article:
http://www.ddj.com/cpp/184403558
It says:
Suppose you want to call methods on a COM object or Automation Server, but have no header files, type library (discussed later), or any programmatic information about the object. Late binding is what makes this possible. In fact, with late binding you can even instantiate and use a COM object [2] on a remote machine.
And in his code:
wcscpy(progid, L"comcalc.calc"); <br />
CLSIDFromProgID( progid, &pclsid); <br />
HRESULT hr = CoCreateInstance(pclsid, NULL, CLSCTX_ALL, IID_IDispatch, (void **)&idsp);
While late binding , If we have nothing (no need) about COM object in remote server. How could CLSIDFromProgId work? Something must be registered in client computer before executing this line so we need dll/exe file(server) itself. Am i wrong?
I don't understand how CLSIDFromProgId could work here.
Thanks...
Edit/Delete Message
|
|
|
|
|
sawerr wrote: wcscpy(progid, L"comcalc.calc");
CLSIDFromProgID( progid, &pclsid);
HRESULT hr = CoCreateInstance(pclsid, NULL, CLSCTX_ALL, IID_IDispatch, (void **)&idsp);
While late binding , If we have nothing (no need) about COM object in remote server. How could CLSIDFromProgId work? Something must be registered in client computer before executing this line so we need dll/exe file(server) itself. Am i wrong?
IMHO the above code snippet is executed on the remote machine, where the COM server is registered.
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.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
