Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL VBA + Microsoft Flexgrid
Hello,
On my computer I use Windows XP Pro, EXCEL 2003 and MS Visual Studio 6. I developed some EXCEL makros that use the Microsoft Flexgrid. I could add Flexgrid to the EXCEL dialogs because of the availability of Visual Studio. Now, if my Makros are executed on other computers it occurs that the Makros will not start. In this case the VBA debugger always points on the first line with ..... object.flexgrid. .... What do I have to do to assure that my Makros can be executed on other computers? Thank you for any support! Best regards, Christian Lehmann |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL VBA + Microsoft Flexgrid
Christian,
ASSUMING that FlexGrid is a redistributable file in design mode (and that's a big assumption -- most controls that come with VS are redistributable in execution mode, but since VBA is essentially always in design mode, you'd need a design-time license for the control -- see the file "redist.txt" in your VS6 folder), you would need to distribute the file MSFLXGRD.ocx to each user, have them copy that file to their "C:\Windows\System32" folder and then use RegSvr32 to register the control with Windows. On each user's machine, go to the Windows Start Menu, choose Run, and enter the following, with quotes, and click OK: RegSvr32 "C:\Windows\System32\MSFLXGRD.ocx" You should get a message indicating that the operation was a success. You could write VBA or VBS code to automate the copy and registration operations. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Christian Lehmann" wrote in message ... Hello, On my computer I use Windows XP Pro, EXCEL 2003 and MS Visual Studio 6. I developed some EXCEL makros that use the Microsoft Flexgrid. I could add Flexgrid to the EXCEL dialogs because of the availability of Visual Studio. Now, if my Makros are executed on other computers it occurs that the Makros will not start. In this case the VBA debugger always points on the first line with ..... object.flexgrid. .... What do I have to do to assure that my Makros can be executed on other computers? Thank you for any support! Best regards, Christian Lehmann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Flexgrid Control | Excel Programming | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
Print data from FlexGrid | Excel Programming |