Re: Mixing native OLE with MFC interface/wrappers - COM Discussion Boards

Re: What type of permissions are needed to resolve Acccess denied for GetDsOfNames to registry entry HKCR\Typelib

7-Jan-13 11:41

Hi,

I am getting a ACCESS_DENIED error message when calling GetDsOfNames Here at work I am not looged on as an adminstrator and have no such rights

The support group here wants to know what type of permission I would need

Not having access to the registry and not being all that of expert I dont know what
answer to give

If am running Windows XP Service Pack 3

If anyone can shed some light would appreciate it

Thanks

Richard MacCutchan7-Jan-13 22:20

7-Jan-13 22:20

I think you need administrator rights to access HKCR keys. You can check this by running regedit to see if it will start under your userid.

One of these days I'm going to think of a really clever signature.

Creating .OCX file hangs

ForNow1-Jan-13 17:44

GetIDsOfNames returning -1

1-Jan-13 17:44

Hi,

While building a Natiave OLE/COM program build hangs (does not complete) trying to build a .ocx file

IS there anotherway to build the ocx that isn't so time consuming

Thankx

ForNow27-Dec-12 12:28

Re: GetIDsOfNames returning -1

27-Dec-12 12:28

Hi,

I am writting a COM app using the MFC wrappers

There are however certain methods/properties which don't have C/C++ prototypes

so I decided to use native OLE functions

I never got by GetIDsOfNames as
what ever method name I insert I get a -1

I have tried native OLE

C++

CoInitialize(NULL);  //native ole
CLSID clsid;         // initialization
HRESULT hr = CLSIDFromProgID(L"Excel.Application",&clsid);

and the MFC wrappers function

C++

_application::CreateDispath

as this method populates

C++

m_lpDispatch

And whatever method property I use I get -1

Any help appreciated

Richard MacCutchan27-Dec-12 21:48

Mixing native OLE with MFC interface/wrappers

27-Dec-12 21:48

You need to use the GetLastError function[^] to determine why it fails.

One of these days I'm going to think of a really clever signature.

ForNow26-Dec-12 15:30

Re: Mixing native OLE with MFC interface/wrappers

26-Dec-12 15:30

Hi,

I have noticed that certain OLE functions dont have MFC wrappers one in particaular Is OpenText

I have noticed also that it seems that for those functions that dont have MFC wrappers, they use a generic AUTOWRAP function

Which is base on native OLE functions
such as IDispatch

I have intlized OLE using MFC/Framework AfxOleInit

to use native ole functions would I have to do intilzations twice

e.g. CoInitlize(NULL) and then CoCreateInstance

I need MFC as I would like use Windows Service in this program

Please Advise

Thanks

DriveByCoder24-Mar-15 7:41

DriveByCoder

24-Mar-15 7:41

You don't need to call CoInitialize() again.

You will need to check to see if the MFC interfaces are dual or not. If they are you can use then as if that are non-automation interfaces. I.e. just go

obj->SomeMethod();

My guess is probably not, in which case you will have to use IDispatch->Invoke(...) which is a real pain.
I'm sure you can find helper code out there on the Web.

_WorkSheet::Paste usage

ForNow19-Dec-12 13:01

Re: _WorkSheet::Paste usage

19-Dec-12 13:01

Hi,

I am trying to paste a .txt file onto
an Excel spreadsheet

Off hand it seemed to me the logical
method would be _WorkSheet::Paste

I have done countless google searches
and have yet to come up with C++
exampe of how this method is used

This is the prototype of the method in Excel.h

C++

void Paste(const VARIANT& Destination, const VARIANT& Link);

When I did research on the data type VARIANT the documentation said its a union for many data types

One of them being a LDISPATCH type

The code below is a snipet of the code I have been stuggling with to get the _WorkSheet::Paste method
to work

My logic was to get a LDISPATCH pointer to the range off cells I was trying to paste onto

However I keep on running into exceptions

If anyone could shead some light on this I would be very gratefull

thanks in advance

C++

CI46023App theApp;       // Main CwinThread
_Application app;        // excel application object
_Workbook objBook;       // workbook object 
Workbooks objBooks;      // ditto
Worksheets objSheets;    // worksheet object
_Worksheet objSheet;     // worksheet
LPDISPATCH myrangeptr; 





app.CreateDispatch("Excel.Application");
  objBooks = app.GetWorkbooks();
  objBook = objBooks.Add(VOptional);
  objSheets = objBook.GetWorksheets();
  objSheet = objSheets.GetItem(COleVariant((short)1));
  myrangeptr = objSheet.GetRange(COleVariant(TEXT("A1")),COleVariant(TEXT("M34")));
  objSheet.Paste((VARIANT &)myrangeptr, COleVariant((short)TRUE));

Jochen Arndt19-Dec-12 21:45

Jochen Arndt

19-Dec-12 21:45

I'm not quite sure if the Worksheet.Paste method does what you want. It will copy text from the clipboard to the specified (or current) selection (see Worksheet.Paste Method[^]). Setting the second parameter to TRUE will not copy the text but place a link. So if you have copied the text from the file to the clipboard, you may use this function but should pass FALSE as second parameter (or COleVariant((long)DISP_E_PARAMNOTFOUND, VT_ERROR) as optional value which uses the default).

However, the first (also optional parameter) is a range object. Just declare the object, assign the return value of GetRange() and pass it to Paste():

C++

Range objRange = objSheet.GetRange(COleVariant(TEXT("A1")),COleVariant(TEXT("M34")));
objSheet.Paste(objRange, COleVariant((short)FALSE));

Re: _WorkSheet::Paste usage

ForNow20-Dec-12 5:21

Re: _WorkSheet::Paste usage

20-Dec-12 5:21

Hi,

I am at home now but from what I remember when I tried to build the code with VISUAL C++ 6.0 I got a build error saying cannot convert paramter 1 from const struct &VARIANT to class Range The documentation says it accepts a range object as the first parm

but the prototype for the code is Paste(const &VARIANT,

Jochen Arndt20-Dec-12 21:04

Jochen Arndt

20-Dec-12 21:04

Sorry, I overlooked the parameter type.

WorkSheet.GetRange() returns a LPDISPATCH which can be assigned to a Range object. You can use the LPDISPATCH returned by GetRange() or access the underlying IDispatch pointer of an existing Range object using the LPDISPATCH() operator to create the required variant:

C++

VARIANT vtRng;
vtRng.vt = VT_DISPATCH;
// Assign LPDISPATCH returned by GetRange()
vtRng.pdispVal = objSheet.GetRange(COleVariant(TEXT("A1")),COleVariant(TEXT("M34")));
// Alternatively, access the IDispatch pointer of an existing Range object
// vtRng.pdispVal = objRange;
objSheet.Paste(vtRng, COleVariant((short)TRUE));

MSDN documentation for MFC OLE wrapper method/prperties

ForNow17-Dec-12 13:10

Re: MSDN documentation for MFC OLE wrapper method/prperties

17-Dec-12 13:10

Hi,

First off I like to thank Richard MacCutchan with helping in setting up my C++ project to generate the MFC OLE wrappers classes

One strange thing unlike the regualar MFC classes CWinThread, CDialog

There doen't seem to be any MSDN docmentation about any of the methods in the wrapper classes

One can only guess by thier name what they do

thanks

Richard MacCutchan17-Dec-12 22:19

Re: MSDN documentation for MFC OLE wrapper method/prperties

17-Dec-12 22:19

See here[^].

One of these days I'm going to think of a really clever signature.

ForNow18-Dec-12 2:28

Re: MSDN documentation for MFC OLE wrapper method/prperties

18-Dec-12 2:28

Hi,

I am finally begining to understand why the Microsoft article said I should create dialog based ontrol as a MFC app needs a main window

I tried to follow the article in creating the project but I wa a bit confused what the srticle meant by changing the IDOK button IDCRUN

I ended up getting some sort of exception when existing Cdialog::Initinstance I beleive it be a invalid Hwnd for the Dialog

COnceputally then the Excel spread sheet is a control with the Cdialog being the mainwindow

Richard the doumentation you pointed me to was about Wrapper classes as MFC frontends the OLE functions

I was looking for documentation of the type Cdialog::GetDefID in native MFC there would be documentation for Range::SetValue for the wrapper classes

Thanks again

Richard MacCutchan18-Dec-12 2:54

about screen reader how to read PDF file

18-Dec-12 2:54

I keep pointing you to MSDN and various related pieces of documentation, but you keep coming back here asking for the same thing. Try using the tools at your disposal (Google, Bing etc) to find what you are looking for.

One of these days I'm going to think of a really clever signature.

BCN-16316-Dec-12 16:01

BCN-163

16-Dec-12 16:01

I have asked a lot about how to read PDF files(just like JAWS, a quit good screen reader), what I want to ask is that does anybody know how JAWS make it. I mean,what kind of tech does JAWS take advantage of. I guess it used MSAA.

I'm trying to do the same thing with JAWS now, so I need your help, if anybody has done such things, please help! Appriciate it.

April Fans27-Dec-12 15:20

April Fans

27-Dec-12 15:20

Hello Bian ChengNan,

With regards to your question, the following link gives you a full and thorough description of the who, what, when, where how.

http://www.indiana.edu/~iuadapts/technology/software/jaws/jaws_faq.html

Hope this helps!

Best of Luck,

With Kind Regards,

April

Comm100 - Leading Live Chat Software Provider

modified 27-May-14 8:34am.

BCN-16327-Dec-12 17:41

BCN-163

27-Dec-12 17:41

3Q for your reply. I known what I asked is a little shame. I apologize. I have visited that website but I still do not know how JAWS makes it. I have make it by myself. thanks again.

April Fans27-Dec-12 20:34

April Fans

27-Dec-12 20:34

Your question is quite interesting actually.

I will be doing more research on it - if I come across anything useful - I will pass it along to you.

Best of Luck!

With Kind Regards,

April

Comm100 - Leading Live Chat Software Provider

modified 27-May-14 8:33am.

BCN-16321-Jan-13 14:41

BCN-163

21-Jan-13 14:41

really thanks for your attention

range setvalue

ForNow13-Dec-12 15:31