PC Review


Reply
Thread Tools Rate Thread

copying macro to multiple excel files

 
 
AyelletOriWolman@gmail.com
Guest
Posts: n/a
 
      14th Feb 2008
Hello,

I need to copy a Macro to multiple excel file.
Is there a way to do this without the need to open every file
individually and doing the work manually?

Thanks
Ori
 
Reply With Quote
 
 
 
 
Mark Ivey
Guest
Posts: n/a
 
      14th Feb 2008
If you will be running the macro from one machine, you might consider
putting it into your personal.xls file.

If this is not the case, you could export the module and import it into your
other files as needed.

Otherwise, you could look over this site and see if it may give you some
other ideas...

http://puremis.net/excel/code/004.shtml

Mark Ivey




<(E-Mail Removed)> wrote in message
news:f093cd32-157b-419c-a6b1-(E-Mail Removed)...
> Hello,
>
> I need to copy a Macro to multiple excel file.
> Is there a way to do this without the need to open every file
> individually and doing the work manually?
>
> Thanks
> Ori


 
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
Copying Multiple files in one file Macro - Liz =?Utf-8?B?TGl6?= Microsoft Excel New Users 2 13th Mar 2007 02:45 PM
Run multiple excel files off of one macro. =?Utf-8?B?YWhzeWE=?= Microsoft Excel Worksheet Functions 1 3rd Oct 2006 11:43 PM
macro for opening all excel files and copying contents roshinpp_77 Microsoft Excel Programming 2 30th May 2006 01:18 PM
Macro copying info/data in multiple excel files into one summary file. Jskasango Microsoft Excel Programming 10 6th Apr 2006 08:27 AM
Copying Excel files and Macro problems Microsoft Excel Programming 1 5th Apr 2004 02:59 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:31 AM.