COM Discussion Boards

OPENING THE VBA EDITOR ON CLICK ON OLEOBJECTS BUTTON

6-Jan-12 16:23

If you only want to view the interface definitions, you can use a tool called OLE/COM Object Viewer that comes along with Visual Studio.
From this tool select the menu option File -> View TypeLib... and point to the proxy-stub dll.
But for this to work, the type library has to be packed into the DLL.

«_Superman_»
I love work. It gives me something to do between weekends.

Microsoft MVP (Visual C++)

Polymorphism in C

archana jain15-Dec-11 0:20

archana jain

15-Dec-11 0:20

Hey,
in my excel plugin , i have dynamically generated the OLEOBJECTS Textbox ..
when i click on them to write something . THEY opens up the
Private Sub cmdActionTxt0_Change()
End Sub
VBA editor
i do not want it to be opened and simply want to write over them.
How is that possible.

How to select the predefined area as WIDTH in PIXEL by HEIGHT IN PIXELS in MSEXCEL for desiging your templates

archana jain14-Dec-11 22:18

archana jain

14-Dec-11 22:18

Hey
I am creating my OWN EXCEL PLUGIN 2010 in vb.net for designing purpose. My requirement is in MY EXCEL sheet i want to select the 1028 By 768 pxiles area for designing .
that area will be calculated automatically on Load of Addin. so that i can start designing in the particular area only.
That are will be filled with WHITE COLOR.
and the selected area of 1028 by 768 pixels can be varied upon my requirement.
please help me as i am new to office tools.

or you can reply me at archanajain@claricetechnologies.com

Adding Workbook In Excel

SB_CodeForFun6-Dec-11 20:02

SB_CodeForFun

6-Dec-11 20:02

Hi,

I have an Excel Addin which loads with Excel Application. Excel Addin then loads a COM dll on the click of Load button.

The loaded COM dll adds an Excel Workbook.

Excel::WorkbookPtr m_ptrDummyWbk;
Excel::WorkbooksPtr ptr_XLWb = m_myExcelPtr->GetWorkbooks();
m_ptrDummyWbk = ptr_XLWb->Add();
m_ptrDummyWbk->PutIsAddin(VARIANT_TRUE);
m_ptrDummyWbk->PutSaved(0,VARIANT_TRUE);

The loaded COM dll is released on the click of Unload button and m_ptrDummyWbk is closed and released.

m_ptrDummyWbk->PutSaved(0,VARIANT_TRUE);
HRESULT hr = m_ptrDummyWbk->Close(VARIANT_FALSE);
m_ptrDummyWbk = NULL
ptr_XLWb = NULL;

Now if i load the COM dll again by clicking the Load Button the application Crashes while adding the workbook

m_ptrDummyWbk = ptr_XLWb->Add();

The error displayed is:

Quote:
Unhandled exception at 0x2f430f9f in EXCEL.EXE: 0xC0000005: Access violation reading location 0x0b0231b8.

What could be the potential cause of this crash and how to get rid of it?

Need Com Help - I'm a beginner

jkirkerx6-Nov-11 8:48

jkirkerx

6-Nov-11 8:48

I have these 2 lines of code, if I remark them out, my function runs fine, but does not add the data to the metabase key. If I leave them in, I can't unload the Variant Array, and I get a CRT Heap Failure upon exiting the function.

I sort of know what it does, it takes the new array entry and converts the type to VT_DISPATCH, and then copies the CLASS MimeMap into the array's last entry.

I have worked hard to get the complete function to work, and it does, it generates the MimeMap Key, loads the data, but I can't exit the function clean, and call it again.

If I need to post more, let me know.

V_VT(&va.pa[cVariants]) = VT_DISPATCH;
V_DISPATCH(&va.pa[cVariants]) = pME;
++cVariants;

Re: Need Com Help - I'm a beginner

«_Superman_»6-Nov-11 15:36

Re: Need Com Help - I'm a beginner

6-Nov-11 15:36

How many elements does va.pa own.
The heap failure is probably occurring because you're exceeding the bounds of the array when you do ++cVariants.

«_Superman_»
I love work. It gives me something to do between weekends.

Microsoft MVP (Visual C++)

Polymorphism in C

jkirkerx6-Nov-11 19:34

jkirkerx

6-Nov-11 19:34

I thought about that. If the mime map key is empty at 0, I add an entry, the +CVariants becomes 1. In the For Loop SafeArrayPutElement, it loops once.

so no existing data, add pME, va.pa = {pa=0x003a7200 DISPATCH = 0x017a8458 } vt = 9, cVariants = 0
the added data is the 0, first array entry, but makes the SafeArray Bound 1, because it can't be 0?

So you don't think that my pME is distorting the va.pa?, I can't see the data, so I don't know.

I'm in Antarctica here on this one, it's not a popular subject, and wrappers have been created to do the job in VB. I'm learning that super hard stuff has been replaced with high level wrappers by MS. Thanks for looking at my post, I really need to pull this off, and move on to my socket issue. I think I'm so close to finishing this function.

if (NULL != pwszAddExtension && NULL != pwszAddType) {						
			CComPtr<IISMimeType>	pME;

			// Build a CCom Pointer and Instance
			hr = pME.CoCreateInstance(L"MimeMap");			
			RETURN_ON_FAILURE(hr);
			
			hr = pME->put_Extension(bstrAddExtension);
			hr = pME->put_MimeType(bstrAddType);
			RETURN_ON_FAILURE(hr);						
				
			// Append pME to the array
			//V_VT(&va.pa[cVariants]) = VT_DISPATCH;
			//V_DISPATCH(&va.pa[cVariants]) = pME;
			//++cVariants;	<- You talkin about this- if 0, then add 1		
				 
			SAFEARRAYBOUND saBound = {cVariants, 0};
			SafeArray sa(VT_VARIANT, 1, &saBound); ,- the bound becomes 1

			VARIANT varArray;
			VariantInit(&varArray);

			V_VT(&varArray) = (VT_VARIANT | VT_ARRAY);
			V_ARRAY(&varArray) = sa.psa;
			
			for (i = 0; i < cVariants; ++i) {
				hr = SafeArrayPutElement(sa.psa, &i, &va.pa[i]);
				RETURN_ON_FAILURE(hr);				
			}

Re: Need Com Help - I'm a beginner

jkirkerx9-Nov-11 7:36

jkirkerx

9-Nov-11 7:36

Oh wow your a genius.

Over all in the end, the cVariants value was wrong when the first array called va was created. It was too small, so the one you pointed out added a value that was not initialized, it ncreased the size of the array, in a space that was too small. So that's why the delete [] va crashed.

So finally after week of messing with this, I broke the program down in 2, worked on the add mime until it was clean, and just added the code to read the current mimes.

I put much weight on your suggestion, but did keep it in mind.

Thanks Superman.

How to use unregistered tlb file

SB_CodeForFun30-Oct-11 23:54

SB_CodeForFun

30-Oct-11 23:54

Hi,

I want to use an unregistered tlb file. To achieve this I figured out that i will need to install the tlb file in WinSxS folder.

Now my problem is how do i create a manifest file with this tlb file. Mt.exe requires -dll option to be used if -tlb file is specified to it.

Can anyone please help me out

Re: How to use unregistered tlb file

DriveByCoder24-Mar-15 7:48

DriveByCoder

24-Mar-15 7:48

You don't need to use side x side. The type library can be loaded as a file and the information you need extracted programmatically. But it won't be much fun. I would suggest that consider other ways to do this. I'm not sure whether the documentation is still around. MS want to discourage COM so I wouldn't be surprised if it had disappeared.

COM Component Late binding trouble

nilarya25-Aug-11 6:28

25-Aug-11 6:28

Hi All,

I have posted this message earlier on the ASP.Net forum, I did not notice there is a separate forum for Co Componenets. However I am moving the post to here, please have a look, any help would be much appreciated.

I am using a third Party Com Component in my ASP.NET application. I dont have much experience with COM Components and I think I have messed up here. Please help.

The Com component has a method which looks like following in the ILDASM:

.method public hidebysig newslot specialname virtual
instance class [stdole]stdole.IPicture
marshal( interface )
get_Preview([in] float64 rWorldMinX,
[in] float64 rWorldMinY,
[in] float64 rWorldMaxX,
[in] float64 rWorldMaxY,
[in] int32 dwPicWidth,
[in] int32 dwPicHeight,
[in] int32 PicType) runtime managed internalcall

In my code behind, I am using

object ComObjLateBound;
Type ComObjType;
ComObjType= Type.GetTypeFromCLSID(new Guid("{89251546-3F1C-430D-BA77-F86572FA4EF6}"));
ComObjLateBound= Activator.CreateInstance(ComObjType);
 
//getting the values from the properties. The properties are in the Com Component 
double viewMaxX = (double)ComObjType.InvokeMember("ViewMaxX", BindingFlags.Default | BindingFlags.GetProperty, null, ComObjLateBound, new object[] { });
double viewMaxX = (double)ComObjType.InvokeMember("ViewMaxY", BindingFlags.Default | BindingFlags.GetProperty, null, ComObjLateBound, new object[] { });
double viewMaxX = (double)ComObjType.InvokeMember("ViewMinX", BindingFlags.Default | BindingFlags.GetProperty, null, ComObjLateBound, new object[] { });
double viewMaxX = (double)ComObjType.InvokeMember("ViewMinY", BindingFlags.Default | BindingFlags.GetProperty, null, ComObjLateBound, new object[] { });
 
//geting the image height and width from a local file
int imagewidth, imageheight, pictype;
imagewidth = 1280; imageheight = 800; pictype = 1;
 
object[] previewDetails = new object[7];
previewDetails[0] = viewMinX;
 
previewDetails[1] = viewMinY;
 
previewDetails[2] = viewMaxX;
 
previewDetails[3] = viewMaxY;
 
previewDetails[4] = imagewidth;
 
previewDetails[5] = imageheight;
 
previewDetails[6] = pictype;
 
 
IPicture picture = (IPicture)ComObjType.InvokeMember("get_Preview", BindingFlags.Default | BindingFlags.InvokeMethod, null, ComObjLateBound, previewDetails);

this fails with a COM Exception like

{"Unknown name. (Exception from HRESULT: 0x80020006 (DISP_E_UNKNOWNNAME))"}

with an ErrorCode of -2147352570 if that means something.

Now this is strange, because the exception type and Error Code remains exactly the same if I use any name instead of "get_Preview".

the COM component also has a Preview Property which looks the following in ILDASM:

.property class [stdole]stdole.IPicture Preview(float64,
float64,
float64,
float64,
int32,
int32,
int32)
I have also tried to use this property to get the IPicture value like:

IPicture picture = (IPicture)ComObjType.InvokeMember("Preview", BindingFlags.Default | BindingFlags.GetProperty, null, ComObjLateBound, previewDetails);

But it also falis with a message that Exception has been thrown by the target of an invocation.

Please note, I am not able to use early binding on this component as it gives me an error message -

Unable to cast COM object of type '<>' to interface type '<>'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{}' failed due to the following error: No such interface supported.

I think I am doing something wrong here. Can you please point out what it is?

Thanks in advance.

tom-englert21-Sep-11 1:20

tom-englert

21-Sep-11 1:20

Hi,

you wrote that you look at the COM component with ILDASM - but you probably examined the generated CLR-interop rather than the real COM component. Since you can't do early binding with that interop, it must have been already messed up, so I would not rely on the information provided by it.
To see what's really provided by the COM object you could have a look at the type library, using e.g. OLE-COM Object Viewer (OleView.exe) from Windows SDK.

nilarya6-Oct-11 23:27

6-Oct-11 23:27

tom-englert wrote:
Since you can't do early binding with that interop, it must have been already
messed up, so I would not rely on the information provided by it.

Thanks tom-englert for your response. Sorry for replying late. I was working on a different module during this time.

you are right, I have examined the CLR-interop version of the component in ILDASM. But I wont say the component has been messed up as I can achieve desired results from the component with the exact same codes in case of a winforms application. In winforms both early binding and latebinding is working for me. I am also able to talk to the Component through Javascript block. But I need this component to run on my codebehind.

I've tried installing OleView previously, but I am using Win7 in my development environment, It seems OleView is not supported in Win 7.

tom-englert7-Oct-11 3:59

tom-englert

7-Oct-11 3:59

If that works in WinForms, then you maybe have a threading problem.
The main thread of WinForms runs in STA, and if your object is designed for STA too ("ThreadingModel=Apartment" in the registry) everything is fine.
But if you call that code from an MTA thread, the interface for the object has to be marshaled, which I assume is not supported by your interface.

nilarya7-Oct-11 22:46

7-Oct-11 22:46

Thanks Tom,
I checked the registry, and you are right again. The value of ThreadingModel is defined as Apartment in there. So does that mean there is no way I can access the component in an asp.net codebehind? is there a workarround for this issue?

nilarya7-Oct-11 22:57

7-Oct-11 22:57

Hi,
I just found the url http://www.guidanceshare.com/wiki/Interop_(.NET_1.1)_Performance_Guidelines_-_Threading[^] where it talks about using ASPCOMPAT attribute on the page while calling STA Objects from asp.net.

I will give it a try.

nilarya23-Oct-11 23:27

23-Oct-11 23:27

Hi again,
I have finally got this COM object to work, but some problem still remains. I changed the code as following:

...     
using System.Threading;
 
namespace...     
protected void Button1_Click(object sender, EventArgs e)
      {
        Thread thread = new Thread(new ThreadStart(STAOperation));
        thread.SetApartmentState(ApartmentState.STA);
        thread.Start();
        thread.Join();
       }      
public void STAOperation()
       {
         CSViewerRL.ViewerClass csv = new ViewerClass();
         csv.Open(filePath, 0, 0);//strange error
         //other codes..
       }

this code works, but once in a while, I am getting a strange error while debugging, which states AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

generally the app runs fine the first time I try to debug, but this error occures mostly on the second or third time I press f5 from my VS while the ASP.Net server is still running. and generally it goes away if I stop the server and run again. I think this problem is because of this new STA thread. Maybe I am not handling the new thread correctly. Or there is some other thing I should look into? Can someone point out whatshould I do under this circumstance?

tom-englert7-Nov-11 6:23

tom-englert

7-Nov-11 6:23

Maybe you should limit the objects lifetime to the lifetime of the thread. Currently the object is destroyed at any time by the GC in the GC thread.
Try calling Marshal.ReleaseComObject before the thread ends, to guarantee a deterministic lifetime of the object.

Unable to register 64 bit COM Server

Vi25-Oct-11 0:39

Vi2

5-Oct-11 0:39

nilarya wrote:
I have also tried to use this property to get the IPicture value like:

C#
IPicture picture = (IPicture)ComObjType.InvokeMember("Preview", BindingFlags.Default | BindingFlags.GetProperty, null, ComObjLateBound, previewDetails);
But it also falis with a message that Exception has been thrown by the target of an invocation.

It's right way, but you should use the reversed order of arguments.
previewDetails[6] = viewMinX; and so on.

With best wishes,
Vita

sandeepkavade17-Aug-11 2:07

sandeepkavade

17-Aug-11 2:07

Hi,

I am trying to create a 64 bit COM server in visual studio 2008 on win7 x64 machine.

Here are the steps I am following:

1. Open Visual Studio.
2. Create ATL Project
3. On ATL Project wizard in application settings select Executable(EXE) then Finish
4. Then Build->Configuration Manger change Platform to x64
5. Build the project.
6. On output window everything seems ok but if I take a look at buildLog.htm then there is a error 'errro PRJ0019: A tool returned an error code from "Performing registration"'.

Even I tried to register from command prompt (with admin rights) but it is not registering. Neither error message nor success message.

Re: Unable to register 64 bit COM Server

Shameel17-Aug-11 2:32

Shameel

17-Aug-11 2:32

Make sure that the DllRegisterServer function exists and is exported. For a function to be exported, it must have an entry in the .def file.

Note: In Visual Studio 2005, the VC++ compiler does not add the .def file name in the project settings by default. Provide a name to the .def file in the project settings. I am not sure if this has changed in Visual Studio 2008.

"Don't confuse experts with facts" - Eric_V

Re: Unable to register 64 bit COM Server

«_Superman_»19-Aug-11 4:18

Regarding SheetCalculate event in Excel API

19-Aug-11 4:18

Try opening Visual Studio with elevated privileges.

«_Superman_»
I love work. It gives me something to do between weekends.

Microsoft MVP (Visual C++)

Polymorphism in C

gtag20-Jun-11 10:02

gtag

20-Jun-11 10:02

Using Excel object library, I have written an application which capture all events.

I have an issue in event called SheetCalculate.

SheetCalcuate event returns IDispatch*. From IDispatch* , I am trying to get sheet name or function cell change for which event is triggered.

Please guide me if any one worked on this.

Thanks in advance.

Re: Regarding SheetCalculate event in Excel API

«_Superman_»13-Jul-11 7:04