I have a workbook that gets update from access every monday morning, I
then drop the information into an excel spreadsheet to manipulate the
data. I have a macro that deletes the columns that are not needed and
adds extra columns. There is then a macro that runs from this data and
updates the information from another programme. What my problem is
that everytime the information updates it gets rid of the macros in the
modules, so i have to paste it in from a saved document.
Is there a way that I can update the information into the given
workbook without overwritting the modules.

Save the modules in your personal.xls file, and run it from there. Then
there is no code in the affected worksheet itself.

--
kassie

never stop learning




"fee" wrote in message
ups.com...
I have a workbook that gets update from access every monday morning, I
then drop the information into an excel spreadsheet to manipulate the
data. I have a macro that deletes the columns that are not needed and
adds extra columns. There is then a macro that runs from this data and
updates the information from another programme. What my problem is
that everytime the information updates it gets rid of the macros in the
modules, so i have to paste it in from a saved document.
Is there a way that I can update the information into the given
workbook without overwritting the modules.