F
fee
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.
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.