G
GHB
Hi,
I received via email attachment (Eudora) a workbook of several
worksheets and which contained some VBA routines. When I open the
workbook from within the email it works fine. However, when I then "Save
As" to a different directory and open it there none of the VBA routines
work. I get the "#NAME?" error in each cell that refers to the routines.
I also notice that the file size is smaller.
When I select
Tools -> Macro -> Visual Basic Editor
I do see the code there but it seems as if it isn't linked to the
spreadsheets.
What is even stranger is that if I go to the Attachments directory and
copy the file to a new directory (using Windows Explorer) the new file
works fine!
Can anyone explain what is going on?
TIA,
-GHB
I received via email attachment (Eudora) a workbook of several
worksheets and which contained some VBA routines. When I open the
workbook from within the email it works fine. However, when I then "Save
As" to a different directory and open it there none of the VBA routines
work. I get the "#NAME?" error in each cell that refers to the routines.
I also notice that the file size is smaller.
When I select
Tools -> Macro -> Visual Basic Editor
I do see the code there but it seems as if it isn't linked to the
spreadsheets.
What is even stranger is that if I go to the Attachments directory and
copy the file to a new directory (using Windows Explorer) the new file
works fine!
Can anyone explain what is going on?
TIA,
-GHB