Help!

External Macro Links - how to make internal

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links RSS
Next:  Outlook freezes when adding contact  
Author Message
InflatableFred



Joined: Aug 02, 2007
Posts: 1



PostPosted: Thu Aug 02, 2007 6:28 pm    Post subject: External Macro Links - how to make internal

I am creating new files from an existing excel file using VBA. The new files contain macros assigned to buttons. To get the macros into the new files, I am exporting and then importing them. I then email the file to another user. All this is done ~150 times by a macro.

All works fine, but the macro reference assigned to the button in the new file is an EXTERNAL reference to the original file (e.g. 'c:\myprog\myfile123.xls'!macro1). A local copy of Macro1 is actually in the file, but the button contains an external link.

How can I make the button reference an INTERNAL LINK only (just macro1)- so it goes and uses the local copy attached to the file?

Thanks in advance,
Fred
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum