DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)
-   Visual Basic 4 / 5 / 6 (http://www.daniweb.com/forums/forum4.html)
-   -   How to write a program to register a chart object in excel? (http://www.daniweb.com/forums/thread61634.html)

BombAppetit Nov 14th, 2006 9:09 pm
How to write a program to register a chart object in excel?
 
Greetings,

How do I write a program that automatically register a chart object that I use in excel macro? Currently the macro's only work on the PC that I am using, since it has VB6 installed, and some other PC which I manually added the chart object to. For other PCs, I had to add mschrt20.ocx into the windows' system32 folder, and manually add the object in "Reference" and "Additional Controls", just to make it work on that PC. How do I write a VB program that automatically do so? If not I have to resort to writing a user manual on copying and pasting the mschrt20.ocx file from a network drive into windows' system32 folder, opening VB editor in Excel, adding reference and controls, all this for first time users. It'd be nicer if I just upload a small application that does all that. Is it possible? How do I go about this?


All times are GMT -4. The time now is 11:20 pm.

Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC