|
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:
VARIANT vtRng;
vtRng.vt = VT_DISPATCH;
vtRng.pdispVal = objSheet.GetRange(COleVariant(TEXT("A1")),COleVariant(TEXT("M34")));
objSheet.Paste(vtRng, COleVariant((short)TRUE));
|
|
|
|
|
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
|
|
|
|
|
See here[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
really thanks for your attention
|
|
|
|
|
Hi,
I have been researching how to automate settting cell values in a excel spreadsheet
I have seen a number of examples
with the following code snipet
range.Setvalue(Colevariant(ColeSafeArray &)
It seem from this that the range object has a setvalue method but I have yet to find where this is documented
Any help would be appreciated
Thanks in advance
|
|
|
|
|
I demonstrated how to use Google in my response to your question below, perhaps you could try it for yourself first.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Is the answer XPATH
XPATH represents a range ?
did a word that correctly
|
|
|
|
|
No idea what that means, but it took one single Google search to find this article[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Hi
Looking at that article I think what I am looking for is in that header file
excel8.h or some other header with excel method,properties definations
is this automatically included with office
|
|
|
|
|
ForNow wrote: is this automatically included with office No idea, you need to read the article and any associated links for the details of how to do it.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Would anyone know where the put_visible method is documented
I think its part of the Excel :: Application object
|
|
|
|
|
Why not try this first[^]?
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
IVideoWindow is not part of the Excel programming interface Application, WorkBook, WorkSheet, Range ?
|
|
|
|
|
Is that a statement or a question?
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Hi,
I am running MicroSoft VIsual C++ 6.0 and tryign to wite com application for excel
My first statemt is #import "libid:00020813-0000-0000-C000-000000000046"
This information matches the uuid generated when using OLE/COM viewer and selecting
view libtype from file drop down menu bar
apperantly libid is not right for the version of excel I am running
|
|
|
|
|
I made a .NET COM DLL (VS2012, C#) it registers fine with regasm, but not with regsvr32. Also when I add the .tlb into installer and extract the com stuff (Installshield 2012) there is no registry entries after I have ran the installer. DLL is 32-bit and I'm using 64-bit Windows.
I have this on the code:
[ComRegisterFunction()]
public static void RegisterClass(string key)
{
StringBuilder sb = new StringBuilder(key);
sb.Replace(@"HKEY_CLASSES_ROOT\", "");
RegistryKey k = Registry.ClassesRoot.OpenSubKey(sb.ToString(), true);
RegistryKey ctrl = k.CreateSubKey("Control");
ctrl.Close();
RegistryKey inprocServer32 = k.OpenSubKey("InprocServer32", true);
inprocServer32.SetValue("CodeBase", Assembly.GetExecutingAssembly().CodeBase);
inprocServer32.Close();
k.Close();
MessageBox.Show("Registered");
}
[ComUnregisterFunction()]
public static void UnregisterClass(string key)
{
StringBuilder sb = new StringBuilder(key);
sb.Replace(@"HKEY_CLASSES_ROOT\", "");
RegistryKey k = Registry.ClassesRoot.OpenSubKey(sb.ToString(), true);
k.DeleteSubKey("Control", false);
k.OpenSubKey("InprocServer32", true);
k.DeleteSubKey("CodeBase", false);
k.Close();
MessageBox.Show("UnRegistered");
}
I've tried to find an answer to this but it seems nothing works.
Error with regsvr32 is:
the module "comclass.dll" was loaded but the entry-point DllRegisterServer was not found.
Make sure that "comclass.dll" is a valid DLL or OCX file and then try again.
modified 29-Nov-12 11:59am.
|
|
|
|
|
Joni_78 wrote: the entry-point DllRegisterServer was not found. There is a fairly strong clue in that message, regsvr32 needs the correct entry point to be in the DLL.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
I've found atleast five solutions to this but none worked. I found that you can save the dll registry entries to reg file with "regasm /regfile:name.reg name.dll"
So I can just add the registry keys to installshield, I wonder if it does everything that regsvr32 does.
|
|
|
|
|
Joni_78 wrote: I wonder if it does everything that regsvr32 does. No idea, I'm afraid, but it would be easy to test.
One of these days I'm going to think of a really clever signature.
|
|
|
|