MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Faster duplication

Posted by Tom on September 20, 2001 6:48 AM

I need to make several copies of a spreadsheet. (Each one is a new file.) which is faster, having the file open and using the "SaveAs", or having a 3rd file's macro doing "Copy"?

Posted by Damon Ostrander on September 24, 2001 1:11 AM


The copy will definitely be faster because it just does an image copy, whereas Excel must gather information from a number of different places prior to doing a save. The difference shouldn't be noticeable unless the file is pretty large or you have to make a lot of copies.