|
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.
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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;
|
|
|
|
|
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.
|
|
|
|
|
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;
hr = pME.CoCreateInstance(L"MimeMap");
RETURN_ON_FAILURE(hr);
hr = pME->put_Extension(bstrAddExtension);
hr = pME->put_MimeType(bstrAddType);
RETURN_ON_FAILURE(hr);
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);
}
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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);
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[] { });
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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?
|
|
|
|
|
|
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);
}
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?
|
|
|
|
|
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.
|
|
|
|
|
nilarya wrote: 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.
It's right way, but you should use the reversed order of arguments.
previewDetails[6] = viewMinX; and so on.
With best wishes,
Vita
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Try opening Visual Studio with elevated privileges.
|
|
|
|
|
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.
|
|
|
|
|
You can use QueryInterface on the IDispatch interface to get at the desired interface -
IDesiredInterface* pI;
pDispatch->QueryInterface(IID_IDesiredInterface, (LPVOID*)&pI); Or you can use the CComQIPtr smart pointer -
CComQIPtr<IDesiredInterface> pI(pDispatch);
|
|
|
|
|
This is a small project skeleton (VC2008 project)
http://www.autohotkey.net/~T800/CopyPath_test.zip
for a menu shell extension.
The problem is that InsertMenu in QueryContextMenu returns TRUE but fails(?), inserting only one menu item when it's supposed to insert two.
No matter what I do I get only one menu item. I tried combinations with menu separators to no avail.
I don't know what's wrong, as far as I can tell everything should work fine. 
But then again, I made stupidly simple mistakes before.
Have a look at the code inside zip, I am going blind with this one.
------------------------------------------------------------------------------
Nevermind, I got it, I needed to provide unique verbs for menu entries inside IShellExtInit::GetCommandString(), like it's explained here.
|
|
|
|
|
i have MSHTML::IHTMLDocument2Ptr pointer loaded with html document.there i can see all style sheets,images,iframe object. iframe object again will contain "src" attributes with source location. i want all iframe or frame objects "src" attributes from html document....
please help me
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
