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?