B
BigFoot
How to save a macro and then later use it in another workbook?
I’ve searched earlier posts and did not find an answer, so here is my
question:
(Excel 2002 running on WinXP Home.)
I have an Excel workbook with a set of charts that get updated once
each week with results (numbers) and the numbers for the current week
are compared to the ones from the pervious week, giving you the week’s
total progress for each entry (row).
There are 7 separate charts, for a total of about 125 rows and I have
recorded Macro’s that will move the data from ‘today’s’ column to ‘last
weeks’ column and update the ‘today’ column with the current
information which then gives me a total of the difference for each row
in the ‘total this week’ column.
Everything works just fine until the workbook is closed, that’s when
all my Macro’s (5) are lost, except for one (2nd one recorded). When
working with the charts there are actually two workbooks open… the one
with the charts and the PERSONAL.XLS workbook where the Macro’s are
stored.
I need to find out what I’m doing wrong in the process that causes the
Macro’s to be lost when the workbooks are closed.
This keeps happening over and over and so far all my reading in the
Excel help files, FAQ’s on various sites has not revealed an answer. Is
there a good how-to somewhere for beginning/novice users (like me) that
deals with using Macro’s? Lots of stuff out there, but I don’t find
much on Macro’s.
TUVM
I’ve searched earlier posts and did not find an answer, so here is my
question:
(Excel 2002 running on WinXP Home.)
I have an Excel workbook with a set of charts that get updated once
each week with results (numbers) and the numbers for the current week
are compared to the ones from the pervious week, giving you the week’s
total progress for each entry (row).
There are 7 separate charts, for a total of about 125 rows and I have
recorded Macro’s that will move the data from ‘today’s’ column to ‘last
weeks’ column and update the ‘today’ column with the current
information which then gives me a total of the difference for each row
in the ‘total this week’ column.
Everything works just fine until the workbook is closed, that’s when
all my Macro’s (5) are lost, except for one (2nd one recorded). When
working with the charts there are actually two workbooks open… the one
with the charts and the PERSONAL.XLS workbook where the Macro’s are
stored.
I need to find out what I’m doing wrong in the process that causes the
Macro’s to be lost when the workbooks are closed.
This keeps happening over and over and so far all my reading in the
Excel help files, FAQ’s on various sites has not revealed an answer. Is
there a good how-to somewhere for beginning/novice users (like me) that
deals with using Macro’s? Lots of stuff out there, but I don’t find
much on Macro’s.
TUVM