I have updated an old 95 vba project to 2010. Works fine on my home computer however when I installed it at my clients office, on 2 different machines, one specific routine stops. This specific routine does work in 95 on their machines.
The problem occurs in the renaming of the new added sheets. I use a temporary space at the bottom of a workbook to collect the existing sheets names (A, A01, A02, B,C etc) then continue the sequence for however many names (new sheets) are needed. On my home computer works fine. At the clients, code stops at the naming (sheets have been added) because it repeats only the first letter (A,A,A,A). Makes NO sense to me. BTW I might add they are still using my original program (Excel95, gasp) which this same routine works fine. 2010 is the issue.
Time issue on this, all help appreciated.
The problem occurs in the renaming of the new added sheets. I use a temporary space at the bottom of a workbook to collect the existing sheets names (A, A01, A02, B,C etc) then continue the sequence for however many names (new sheets) are needed. On my home computer works fine. At the clients, code stops at the naming (sheets have been added) because it repeats only the first letter (A,A,A,A). Makes NO sense to me. BTW I might add they are still using my original program (Excel95, gasp) which this same routine works fine. 2010 is the issue.
Time issue on this, all help appreciated.