PC Review


Reply
Thread Tools Rate Thread

Saving Workbook with embedded VBA routines

 
 
GHB
Guest
Posts: n/a
 
      4th May 2005
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook Don Microsoft Excel Misc 0 20th Apr 2008 05:51 AM
saving a workbook, naming it and saving it to a specific path MJKelly Microsoft Excel Programming 2 19th Aug 2007 10:37 PM
Saving a sheet in a workbook as .csv but not changing workbook name gloryofbach Microsoft Excel Programming 3 30th Oct 2005 09:50 PM
Saving Workbook with VBA routines - clarification.... GHB Microsoft Excel Discussion 0 4th May 2005 06:49 PM
Saving a Workbook: Forcing User to Rename before Saving Rollin_Again Microsoft Excel Programming 5 16th Apr 2004 03:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:56 AM.