Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
error when copying large numbers of sheets into 1 workbook
I tried their first workaround - a goofy, hard-coded if statement to stop the process before I was getting the error, then code to save the file with a temporary name, close it, open it, then continue. It seems to work. If x = 30 Then TempFile = "C:\temp9999.xls"...- bjele
- Post #12
- Forum: VBA Visual Basic for Applications (Microsoft)
-
error when copying large numbers of sheets into 1 workbook
I am encountering this very problem right now. Back in Excel 97, this was always a "Sheet111111" problem after 127 sheets, but like you - I am encountering this around sheet 51. Finally, Microsoft has posted a new theory on the matter. They suggest the problem is with having a named range in...- bjele
- Post #11
- Forum: VBA Visual Basic for Applications (Microsoft)
