Save VBA changes only

[PCLIVE]

Is there away to just save the VBA changes without saving other data in the
workbook? For example, I'm using a template that imports data from another
workbook when it is opened. Now I want to add or change some of the code
within the workbook and save it. However, I do not want to save the
imported data.

Is this possible?

Thanks,
Paul

--

 

[Patrick Molloy]

alternatively export all the changed modules - you can just "drag" thenonto
the desktop.
then re-open the workbook, delete the changed modules from the workbook, and
then drag them in off the desktop
then use EDIT/ Compile