|
CUJ had an article about a year ago on doing this through COM, you essentially create a COM object which manipulates an Excel table. I can't remember the details, but it's probably online at www.cuj.com
Christian
I have come to clean zee pooollll. - Michael Martin Dec 30, 2001
Picture the daffodil. And while you do that, I'll be over here going through your stuff.
|
|
|
|
|
|
i don't want to automate excel i would like to use excel as you could use it with vb for application in the sense that from a cell you could call the function you need which have been initially implemented in vc++.
So do you think that i could information and samples for my application?
thanks
gerald
|
|
|
|
|
You can call a DOS program using the VBA Shell statement in sync or async.
An application can be called using the VBA AppActivate statement.
So you can implement your automation functions in VC++ apps.
Hope it helps...
Atul
Sonork ID : 100.13714
|
|
|
|
|
If anyone know where i can find some guides or tutorials
about ucing vc6.0++ (windows messages,tree controls DAO,..);
plese ,contact me.
nikola
|
|
|
|
|
This question is puzzling. The Code Project is just what answers your question.
Just type http://www.codeproject.com/index.asp into your IE 6 address bar and wait for it to load. That's all.
Regards
Nish
Sonork ID 100.9786 voidmain
www.busterboy.org
If you don't find me on CP, I'll be at Bob's HungOut
|
|
|
|
|
As Nish said, The Code Project is a fantastic resource.
You can also try the MSDN Library: http://msdn.microsoft.com.
Jon Sagara
What about ?
Sonork ID: 100.9999 jonsagara
|
|
|
|
|
What steps would be required to convert a class
CSortListCtrl to a CSortListView...?
I've already done:
1) CSortListView : public CListView
2) Changed all occurances of CSortListCtrl to CSortListView
3) Add GetListCtrl()
3) Add IMPLEMENT_DYNAMIC/DELCARE_DYNAMIC..?
Am i missing anything...?
Thanx
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
I know there's an article on MSDN about doing this. It involves some undocumented stuff in CControlView (the base class of CTreeView, CListView, etc.). It should be easy to find on the MSDN site.
--Mike--
"Everyone has figured out what 'service pack' really means, so they had to go and change the language. Perhaps this is what Bill was talking about in the 'security is top priority' letter."
-- Daniel Ferguson, 1/31/2002
My really out-of-date homepage
Sonork - 100.10414 AcidHelm
Big fan of Alyson Hannigan.
|
|
|
|
|
I started realizing it was gonna be more work that i was willing to put effort into at the moment, so I just through the control into formview.
Hopefully this works
Thanx!
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Hi,
I have set a DNS name to my computer which is different from my computer name.APIs like GetHostName, GetHostByName only give the DNS names.Is there anyway of programmatically finding out my computer name?
Thank You.
Yamuna.E.
|
|
|
|
|
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sysinfo/sysinfo_08f9.asp">GetComputerName</a>
Joaquín M López Muñoz
Telefónica, Investigación y Desarrollo
|
|
|
|
|
|
Hi,
Pls help..I got the DSN names by using SQLDataSources().
How is it possible to connect to a particular DSN .
|
|
|
|
|
SQLConnect()
Mazy
Don't Marry a Person You Can Live With...
Marry Someone You Can Not Live Without
|
|
|
|
|
also:
SQLDriverConnect
Mazy
Don't Marry a Person You Can Live With...
Marry Someone You Can Not Live Without
|
|
|
|
|
Hi,
Pls help..I got the DSN names by using SQLDataSources().
|
|
|
|
|
my program runs almost fine, when i compile there are no errors.
but if i wrie one special line of code, the whole program crashes
if you want to tell me how to fix it
i will send you the code or whatever you want me to do, but i cannot post it here.
Thank you.
|
|
|
|
|
What does the program do? And what is the special line which causes a crash? What is the error it shows when it crashes?
Atul
<marquee bgcolor="yellow" direction="LEFT" behavior="SCROLL" scrolldelay="250" scrollamount="5">
Sonork ID : 100.13714
|
|
|
|
|
position = tempInvestors->binarySearch(tempInvestors->getInvestorsList(),0,9,tempSS);
*tempInvestor = tempInvestors->getInvestor(position);
tempAB = tempInvestor->getAccountBalance(); //AccountBalance Of Buyer
// Here i'm performing another binary search to look for the
// specific stock that has that same stockTicker
position = tempStocks->binarySearch(tempStocks->getMyStocks() , 0, 14, tempST);
*tempStock = tempStocks->getStock(position);//THIS LINE IS THE ERRONEOUS ONE
tempIV = tempStock->getInitialValue(); // storing the stockprice in tempStockPrice
//ok I have the same piece of code in another method and i copied just the way it is, but it works fine without if you comment ou that line only in the second method??
it never crashes if i keep it in the first method only.
Thanks
|
|
|
|
|
position = tempInvestors->binarySearch(tempInvestors->getInvestorsList(),0,9,tempSS);
*tempInvestor = tempInvestors->getInvestor(position);
tempAB = tempInvestor->getAccountBalance();
position = tempStocks->binarySearch(tempStocks->getMyStocks() , 0, 14, tempST);
*tempStock = tempStocks->getStock(position);
tempIV = tempStock->getInitialValue();
Do you mean that the above code when pasted into another member function causes the crash? What is the error message?
Atul
Sonork ID : 100.13714
|
|
|
|
|
can i send you the code?
i mean to your email!
|
|
|
|
|
Good boy, Marwan!
Nish
Sonork ID 100.9786 voidmain
www.busterboy.org
If you don't find me on CP, I'll be at Bob's HungOut
|
|
|
|
|
LOL
:) Good boy, Marwan!
Nish :)
You can send it but before that do two things (It may save you the burden of
sending...)
1) What is the error seen?
2) Debug your code
Below is a step by step process. I assume you are using Visual Studio (MS
VC++ IDE).
a)Open your project in the VC++ editor.
<HR></HR>
b) Go to the file in which you have pasted the second piece of offending code
i.e. this
position = tempInvestors->binarySearch(tempInvestors->getInvestorsList
(),0,9,tempSS);*tempInvestor = tempInvestors->getInvestor(position);tempAB =
tempInvestor->getAccountBalance();
performing another binary search to look for the
that same stockTickerposition = tempStocks->binarySearch(tempStocks-
>getMyStocks() , 0, 14, tempST);*tempStock = tempStocks->getStock
(position);
();
<HR></HR>
c)Insert a Breakpoint on the first line of your seemingly offensive code. You
do this by right clicking on the far left side of the line where you see the
grey (grey color is the default) band (column). You will get a drop down list
from which you select the first "Insert / Remove Breakpoint". Once it is
clicked you will see a nice round filled (maroon by def) bullet in the column.
<HR></HR>
d)Make sure that you are building in debug mode.
<HR></HR>
e)Now press "F5" to start your debug session. You will go to VC++ IDE Debug
mode and if your app has an GUI / console interface you will see it.
Depending on whether this piece of offensive code (hereby referred to as OC)
is called or you have to i/p something for it to be called you will either be
seeing the OC with an arrow in the debugger(i.e. your proggie has been
stopped there so that you can check the parameter values) or you will land in
your program.:omg:
<HR></HR>
f)If you land in your proggie while it's waitin for your i/p then i/p
something so that the OC line 1 is called.
<HR></HR>
g)Now if you see the arrow (yellow by def) use the following key to execute
your program step by step.
"F10" to step over OC line num one
"F11" to step into the "binarysearch" member function after which you can use "F10"
<HR></HR>
h)Remember that whichever key you press watch for the consequences down in
the Auto Watch variables window in which you will see your relevant auto variables. To check any other variables, Type them(name) in the
Watchn window. After every step you execute of your proggie check for
any logic,pointer discrepancies.
<HR></HR>
i)If while this stepping your proggie crashes you will nail the OC. If luck
favors you it will be that same line otherwise check a few lines of code
before that OC line.
<HR></HR>
j)If you want to stop debugging press Shift+F5
Whew hope I make sense.
Atul
Sonork ID : 100.13714 netdiva
|
|
|
|
|
every thing you said really makes sense, but in point f
f)If you land in your proggie while it's waitin for your i/p then i/p something so that the OC line 1 is called.
here I have a file that i want to give to the program, i don't want to do it manually coz it is a long file.
do you know how do i make it read from that input file, instead of waiting for me to input the data from the keyboard?
thanks
appreciate your efforts to answer my question.
|
|
|
|