Will from London
Board Regular
- Joined
- Oct 14, 2004
- Messages
- 220
Hi
My company has just changed my PC from:
Windows 7 (32 bit), Office 2010 with 4GB of RAM (Intel i3-4160T 3.1GHz) to
Windows 7 (64 bit), Office 2013 (32 bit) with 8GB of RAM (Intel i3-2120 3.3GHz)
A VBA macro took about 7 minutes on my old PC but after 2 hours of running on the new PC it had only processed about half the data. The code essentially loops through each line of 7 CSV files (ranging from 10k to 200k lines), does a little bit of manipulation and then writes the line to 7 new CSVs. Even on my even older PCs it took a few minutes not hours.
I've seen that VBA code on 64-bit Excel needs to be slightly different (declared Long's etc) but I've still got 32-bit Office so does anyone have any ideas?
Thanks in advance
Will
My company has just changed my PC from:
Windows 7 (32 bit), Office 2010 with 4GB of RAM (Intel i3-4160T 3.1GHz) to
Windows 7 (64 bit), Office 2013 (32 bit) with 8GB of RAM (Intel i3-2120 3.3GHz)
A VBA macro took about 7 minutes on my old PC but after 2 hours of running on the new PC it had only processed about half the data. The code essentially loops through each line of 7 CSV files (ranging from 10k to 200k lines), does a little bit of manipulation and then writes the line to 7 new CSVs. Even on my even older PCs it took a few minutes not hours.
I've seen that VBA code on 64-bit Excel needs to be slightly different (declared Long's etc) but I've still got 32-bit Office so does anyone have any ideas?
Thanks in advance
Will