ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Save VBA changes only (https://www.excelbanter.com/excel-programming/429893-save-vba-changes-only.html)

PCLIVE

Save VBA changes only
 
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

Save VBA changes only
 
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

"PCLIVE" wrote in message
...
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

--





All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com