Hi,
I've got this wierd error message (translated from swedish to english)
"To many excel formats". I appears when I use a macro to copy alot of sheets from alot of workbooks (one sheet from each workbook). I've had problems when I've tried this before. The error "Too many arguments" has appeared, but I solved that by saving, closing and opening the workbook having all the sheets copied into it and then continuing copying sheets into it. every 50 sheets or so. Now that this new error occured I've tried to save the workbook every 10 sheets, just to be sure its not that problem, but its not. I'm pretty sure its due to the fact that the number of sheets beeing copied keeps increasing, because it has worked fine until now. I just passed about 120 sheets, which shouldnt be a problem because I copied over 600 in another project.
Does anyone have any ideas? I guess I have a few that could work, but they are alot of work so I'm looking for an easy fix here.
Best regards
Erik
I've got this wierd error message (translated from swedish to english)
"To many excel formats". I appears when I use a macro to copy alot of sheets from alot of workbooks (one sheet from each workbook). I've had problems when I've tried this before. The error "Too many arguments" has appeared, but I solved that by saving, closing and opening the workbook having all the sheets copied into it and then continuing copying sheets into it. every 50 sheets or so. Now that this new error occured I've tried to save the workbook every 10 sheets, just to be sure its not that problem, but its not. I'm pretty sure its due to the fact that the number of sheets beeing copied keeps increasing, because it has worked fine until now. I just passed about 120 sheets, which shouldnt be a problem because I copied over 600 in another project.
Does anyone have any ideas? I guess I have a few that could work, but they are alot of work so I'm looking for an easy fix here.
Best regards
Erik