Footer Macro
 

I have recorded a footer macro that inserts the file name & path as well as
the date and time. I have saved this macro to my personal macro workbook -
when I run this macro it seems to take several minutes to run - I get the
hour glass and have to wait.

Did I do something wrong?

Footer Macro
 

Have you checked the macro using the editing feature to see if any extraneous
code got inserted?


"Erika" wrote:

I have recorded a footer macro that inserts the file name & path as well as
the date and time. I have saved this macro to my personal macro workbook -
when I run this macro it seems to take several minutes to run - I get the
hour glass and have to wait.

Did I do something wrong?

Footer Macro
 

No I have not done that, is the Editing feature something this is in the
Visual Basic Editor?

"Peter Ellis" wrote:

Have you checked the macro using the editing feature to see if any extraneous
code got inserted?


"Erika" wrote:

I have recorded a footer macro that inserts the file name & path as well as
the date and time. I have saved this macro to my personal macro workbook -
when I run this macro it seems to take several minutes to run - I get the
hour glass and have to wait.

Did I do something wrong?

Footer Macro
 

Editing the macro brings up the Visual Basic Editor. You will need some sort
of programming knowlege to edit this. Your macro sounds quite simple though
so the code will probably not be too complicated.

To access, Use Tools | Macro | Macros, then select the macro and click the
edit command button. This will bring up the Visual Basic Editor.

If you are changing header and footer information, their might be a lot of
lines in the macro for header and footer settings that you do not need reset.
I just recorded such a macro and found that to be true. Deleting any
lines that make unneeded settings might speed up the macro.

If you are not sure about this, or are unfamiliar with a programming
language, get some help first. The code should be readable though as to what
is going on and what is being set.


"Erika" wrote:

No I have not done that, is the Editing feature something this is in the
Visual Basic Editor?

"Peter Ellis" wrote:

Have you checked the macro using the editing feature to see if any extraneous
code got inserted?


"Erika" wrote:

I have recorded a footer macro that inserts the file name & path as well as
the date and time. I have saved this macro to my personal macro workbook -
when I run this macro it seems to take several minutes to run - I get the
hour glass and have to wait.

Did I do something wrong?