? macro slows when other wkshts open

[drun]

I have a macro that runs well when it is the only xl file open. However, if there are other xl files open it slows down dramatically, but only when those other xl files have macros in them as well.

Essentially what my macro does is copy several sheets to the beginning of the file and moves those sheets to a new file.

Where the macro slows down is during the move. Sometimes after running it several times. I get an error that says Move method of sheets class failed.

Any idea what would cause this?

[Bryan Hessey]

I have a macro that runs well when it is the only xl file open. However, if there are other xl files open it slows down dramatically, but only when those other xl files have macros in them as well.

Essentially what my macro does is copy several sheets to the beginning of the file and moves those sheets to a new file.

Where the macro slows down is during the move. Sometimes after running it several times. I get an error that says Move method of sheets class failed.

Any idea what would cause this?

Todays 'Word of the day is 'Resources'.

How large are the workbooks involved, and with how much 'lookup' or link data?
Do you have a fragmented disc, are you short of memory.

Can you Copy the sheets directly to the new workbook? - this would minimise the resources needed, (record a macro and do the Copy etc to get the code)

Any other clues?
---