Macro opening new workbooks only on one computer!

[NatalieEC]

Hi All,

I have written a macro that works really at work, but when I brought it home tonight and starting playing with on my laptop, it stopped working properly.

My spreadsheet has a summary tab with the macro button. When I click the button, it goes to sheet one, dumps a bunch of csv files in, extracts some parameters, place them in the summary tab, copies a tab named "1", renames it ("2"), dumps data into the new tab and extra data into the summary file, etc.

But when I run it now, it immediately opens a new work work that says Book 1 and copies only the summary tab over. Not the other tabs, either. It only started happening on this laptop. Is there a setting maybe?

I will attach my code if needed (hopefully not and its a quick fix). I have some confidential things in the macro, so I can edit that later if I have to.

Thanks!

[xladept]

You're probably copying without specifying a before or after sheet which will create a new book