Hi everybody !
I have an Excel WorkBook that contains VBA code. I would like to copy this VBA code by FoxPro automation in an other Excel WorkBook.
I explain why I want to do this...
My customer wants to use Excel functionnality to make his page setup for some reports. So I created a FoxPro DLL which I can access from VBA in Excel. With this DLL I can write functions in VBA that retrieves informations the way I want from my FoxPro database. The VBA code has to be in each WorkBook my customer uses so he can acces my VBA functions. I have code on some events of the WorkBooks an a code module for my functions. For the moment, each time I update that code or each time I add a new function, I have to open my customer's Excel application an manually copy and paste the newest version of the code in each WorkBook he have. Now I would like to send him only one Excel file that contains the new version and my FoxPro application will do the update for all WorkBooks (Excel files) without any intervention.
I use Visual FoxPro 6, Excel 97 and Excel 2000
Thanks in advance...
Excuse my poor english !! :)