How to update VBA code without disturbing Excel data?

[sjh]

Hi,

My customer is using the Excel VBA application that I created. I am planning to release an updated version.

For the customer to use the updated one, he has to copy the data from every sheet on the old version to a new one. Is there a better way to accomplish this?

Thank you for your input!

 

[RobBroekhuis]

I take it your application is in regular workbook format, not in addin format. You can distribute your updated code as a new workbook which opens the old one and copies the data into itself, or, the other way around, exports its VBA components and imports them into the old application. I think the first method is a little cleaner. It would involve, as the last pair of steps, saving the old workbook as a backup in a different name, and saving the new one in the name of the original one. If you need some pointers how to make it all work, ask help on specifics right here.
Good luck


Rob

 

[sjh]

Thank you Rob! Your suggestion would work perfectly for my situation. But I have no clue on where to start. How do I backup an old workbook and rename the new one? And what are the commands to use for data copying?

I would appreciate it very much if you can give me some pointers...

Thank you,