|
Hi,
I write into Excel over COM
My Problem is the interface IDispatch. I can't get acces to a SeriesCollection object with this interface.
I've tried to map anotherone but this doesn't works. The compiler says the code is ok but when executing i got an invalid pointer massage
Here are some parts of my code:
_ApplicationPtr pXL;
pXL.CreateInstance(L"Excel.Application.9");
.
.
.
pXL->Range["Messwerte!B5"]->Value2= 35.6;
pXL->Range["Messwerte!B6"]->Value2= 32.7;
pXL->Range["Messwerte!B7"]->Value2= 33.6;
pXL->Range["Messwerte!B8"]->Value2= 37.6;
pXL->Range["Messwerte!B9"]->Value2= 34.6;
pXL->Charts->Add();
pXL->ActiveChart->SetSourceData(pXL->Range["Messwerte!B5:Messwerte!B9"], _variant_t((long)xlColumns) );
pXL->ActiveChart->ChartType = xlLineMarkers;
pXL->ActiveChart->Location(xlLocationAsObject,"Messwerte");
pSheet->Shapes->Item( _variant_t((long)1) )->Top = 0;
pSheet->Shapes->Item( _variant_t((long)1) )->Left = 0;
pSheet->Shapes->Item( _variant_t((long)1) )->Width = 400;
pSheet->Shapes->Item( _variant_t((long)1) )->Height = 200;
// it works until here now i want change some attributes of the chart so i have to use an SeriesCollection Object
IID IID_ISERIESCOLLECTION = {0x00020813-0x0000-0x0000-0xC000
0x000000000046};
ISeriesCollection *pscMyCollection;
pXL->ActiveChart->SeriesCollection( _variant_t((long)1) )->QueryInterface(IID_ISERIESCOLLECTION, (void**)&pscMyCollection);
pscMyCollection-> //here i want to acces members, e.g. Item, Add.. but it doesn't work
Thanks for Help
|
|
|
|
|
seemed to be the wrong Inteface.
Does perhaps someone know an InterfaceID with which i,ve got acces to SeriesCollection member?
|
|
|
|
|
I'm trying to create multiple buttons on a dialog page dynamically and have been able to get the buttons to appear, but i can't get the tools tips to work. Before I did this I was using static buttons and they worked fine. Now everything works except the tool tip. Could this be because I'm just using one resource button on that dialog page?
m_Icon[ndx].Create(_T(""), WS_CHILD | WS_VISIBLE | WS_TABSTOP , CRect(0, 0, 0, 0), this,IDC_BTN );//IDC_BTN is the only resource on dialog created in the dialog editor
Any idea to the limit of the number of objects that can be put on a page? Looks like I may have a max of 600 plus all the stuff to make the page into a x/y graph.
Thanks for any help
|
|
|
|
|
As I understand it, applications which share a dll will share the code segment of the dll. Each application will get a new data segment for the data in the dll.
This can be overridden with the #pragmas such that a shared data segment can be used.
And I understand that variables must be initilized in order to be in that data segment.
Now when I create a class, can I specify what data segment it's data members will be in?
related question:
Let's say I have an array[] of some type that is supposed to be member data of a class. Should I create it as global (to the shared memory segment) and then only have a pointer to it in the class? If so, will all instantiations of the dll class point to the same data?
Thanks,
-KS
|
|
|
|
|
Is it possible to have one button do the function of two buttons in MFC.
For example: I have two buttons Beginner Mode, Advanced Mode. The beginner mode puts the user in different settings than the advanced mode. I want them to both be in one button., so when the user clicks on beginner mode, the beginner settings show and the button text changes to advanced mode.
|
|
|
|
|
well, you can internally keep track of the mode via a variable, lets say bool bAdvancedMode = false. Depending on the value you can handle it like that:
voice OnButtonClick()
{
if(bAdvancedMode)
ShowAdvancedProperties();
else
ShowBeginnerProperties();
}
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
you can,
you need to keep a variable somewhere to keep the "mode" you're in.
you can also use a checkbox, to toggle on/off the advanced/beginner mode.
in the case of the checkbox, the button itself becomes the variable (unless it's private, or you need the variable to be a global state)
Max.
Maximilien Lincourt
For success one must aquire one's self
|
|
|
|
|
Yes this can be done. I've done this with CButtonSt in the articles section on this board.
Use the SetWindowText to set the text of the button to what it should say then just keep track so on the button click you know what functions to call.
|
|
|
|
|
Assuming that you have a property that identifies whether or not they are in beginner mode or advanced:
void CFunDlg::OnExample()
{
if(CFunDlg::m_bAdvanced)
MessageBox(_T("User has selected the Adavanced Option."));
}
-Nick Parker
|
|
|
|
|
I want to deal with files using fstream, like:
std::fstream file;<br />
file.open("imi.asp");
But i want to have some kind of error message if the file does not exists. The code i have written above is not returning any error in case if the file is not present. Please tell me that how can i find that the file does not exist.
|
|
|
|
|
How about:
std::fstream file;
file.open("imi.asp");
if(!file.is_open())
{
cerr << "Unable to open file!\n";
exit(1);
}
Hope this helps,
Nathan
---------------------------
Hmmm... what's a signature?
|
|
|
|
|
You could also:
fstream infile;
infile.open("mystuff.dat", ios::in);
if(!infile)
cerr << "mystuff.dat couldn't be opened.\n";
-Nick Parker
|
|
|
|
|
Hello!!!
1.
How can I change the Font in a HeaderCtrl??
When I make it in a ListView like this:
CListCtrl * theCtrl = GetListCtrl ( );
CHeaderCtrl * theHeader = theCtrl->GetHeaderCtrl;
theHeader.SetFont(& font);
The Font is not right !!!
2.
The second Problem is that i want to have a CHeaderCtrl in a View . How can I do this??
I want to have it in a CEditView at the Top.
Thanx for helping me........
Dirk from Germany
|
|
|
|
|
schoni wrote:
The second Problem is that i want to have a CHeaderCtrl in a View . How can I do this??
Use a CListView.
|
|
|
|
|
Hello!!!
How can I change the Font in a HeaderCtrl??
When I make it in a ListView like this:
CListCtrl * theCtrl = GetListCtrl ( );
CHeaderCtrl * theHeader = theCtrl->GetHeaderCtrl;
theHeader.SetFont(& font);
The Font is not right !!!
The second Problem is that i want to have a CHeaderCtrl in a View . How can I do this??
I want to have it in a CEditView at the Top.
Thanx for helping me........
Dirk from Germany
|
|
|
|
|
For the font to be used, it has to be created correctly and be in existence the lifetime of the header control that will be using it. So make the font object part of your class, nt locally on the stack.
Roger Allen
Sonork 100.10016
Were you different as a kid? Did you ever say "Ooohhh, shiny red" even once? - Paul Watson 11-February-2003
|
|
|
|
|
I'm having some problems here. What I want to do is access a sybase stored procedure through a c++ program. The problem I'm having is, 1) adding a data source to an already existing program. (I'm using Microsoft Visual Studio). 2) how to call the stored procedure and how to acess the results.
If anyone can give me any help it would be most appreciated.
ICXC
NIKA
|
|
|
|
|
http://www.codeproject.com/database/readdb.asp[^]
Update ur driver in the code to the sybase driver installed ( u can check it in the ODBC in control panel)
and use SQL like
EXEC storedProcedure ( or call , i dont recall exactly )
eg.
exec sp_FileExist 'F', 'CLNHLDY_DBF'
Hope this helps
Papa
while (TRUE)
Papa.WillLove ( Bebe ) ;
|
|
|
|
|
You need to either use the Sybase CTlib directly or use a higher level abstraction layer, such as ODBC or ADO.
If using ODBC, you need the Sybase ODBC driver installed on the system and configured correctly. Once that is done, you can use SQLExecDirect or SQLPrepare/SQLExecute to invoke the SP. Remember that you either need to change to the appropriate database (using a CTLib function or SQL USE {database} query -OR- embed the database name in the procedure)
sprintf(caSQLBuf,"exec %s.dbo.MyProcedure '%s'", caDBName, caParam1);
SQLExecDirect(caSQLBuf).
Let me know if you need a generic ODBC class library or if you don't want to roll your own.
|
|
|
|
|
Can anyone think of a way to simulate the Jave concept of a 'package' access modifier (next to public, protected, private) in C++? For those who don't know Java: 'package' will give access to members for all classes that are in the same package, that would be in the same directory in Java; but what I would like to have is something that works like a namespace. Basically, to restrict access to classes and class members to othere classes that are in the same 'namespace'. In concreto, I have written a library with a public interface, and I want to disallow access to the internals of the library. It's an in-house library, but still, I would like to make sure that people don't start doing stuff without using the 'official' API. Thanks.
|
|
|
|
|
Hi,
I was happily editing my code today when I suddenly found that I had lost 30 classes! They no longer appear in the 'Workspace' area on the screen. If I look in the 'Files' tab the relevant files are there and the code compiles just fine. What the hell have I done????????
Any ideas of how I might get them to reappear would be brilliant.
Many thanks & completely confused,
Ali
|
|
|
|
|
It;s a common bug, only modify the header, and you will be the class in your workspece.
For example add an Enter in your header..... 
Best Regards
Carlos Antollini.
Pi Five[^]Creator
Sonork ID 100.10529 cantollini
|
|
|
|
|
Thank you, thank you, thank you ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
I've been adding and deleteing files for the last hour trying to sort it out. I obviously hadn't got the right file.
I took your advise and edited the headers, and bingo it is all there again. Phew, what a relief!
Thanks again,
Ali
|
|
|
|
|
Hi,
The .ncb file contains ClassView browser information.
I believe, some of your .ncb(if you're using multiple projects) file permission may have changed. That is the cause. To check that, create a sample program and change .ncb file to read-only. Now you reload the project, you will not be able to see any classes in the classview.
Hope this helps, if not better you move all your .ncb files to some other location. so that your .dsw/.dsp will recreate your class view again.
regards
~Hari~
|
|
|
|
|
Thanks for the help, I ran my project in the morning and they had all gone again, and when I looked closely not all of my classes had come back. But I tried deleting that file and they are all there now! Cheers!
Many Thanks,
Ali
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
