I want hopefully, to export ALL modules, forms, objects etc in one workbook to another and if that can't be done than at least all modules and/or objects. This is so I can change code but leave the formulas/values etc in the main excel sheets. Basically it would need to delete all VBA code and copy, I guess from a text file to insert the new code, at least for modules and objects. Forms, I don't know how that can be done?
thanks for your help! scott
Just export the modules, File>Export in the VBIDE, and import them in the other workbook.
Or open both workbooks, and drag-copy from one to the other project in the VBIDE.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
That would take to long to do each of 152 macros, forms and objects since I think I can only do one at a time. Can a macro be coded to take line by line and save it to a text file and another macro be coded to read the text file and load all those lines back into VBA. Same with objects. But what about teh Forms section?
Check out this tool:
http://www.jkp-ads.com/Download.asp#copyvbaproject
Posting Permissions
Reply With Quote
