Macro for multiple files???
Posted by John on August 20, 2001 9:36 AM
Hello! I have many files to copy a piece (the same piece) in a spreadsheet. Then I need Open File1, copy, paste, close file1, open file2, copy, paste, close file2,... (sometimes until 100). Does anyone a Macro to do it?
Posted by Malc on August 21, 2001 12:39 AM
Post your Email Address I'll send it
Posted by Ivan F Moala on August 21, 2001 1:42 AM
For an idea to get you started see;
27608.html
Ivan
Posted by John on August 21, 2001 4:50 AM
Re: Post your Email Address I'll send it
John2001@zipmail.com
Posted by Malc on August 22, 2001 2:21 AM
Thats a clever idea. Might modify my file
