A few more thoughts:
The macros are stored in a Personal.xls file that resides in the XLSTART folder in documents&settings/[user]/applications/microsoft/Excel
I would be happy to post the macros, but was reluctant to do so as the post may seem overly complex and scare off some good thoughts!
Thanks!
Turning off Screen Updating and automatic Recalculation while your macros are running can speed things up greatly. Consider that to display things correctly, the spreadsheet may be recalculating.
For such a long data process, you may want to turn on Screen Updating to cause a re-display every 30 seconds or so, to show that things are still processing.
FrankBoston is the pen name for Andrew Garland, Lexington MA
Hi
1) Presumably the machines are memory size compatible, and virtual memory and other "Physical" type issues have similar characteristics.
2) Are there any other macros in the user's personal.xls that may be impacting? Event macros???
3) Check the priority of Excel on both machines. Open up the task manager, select processes, right click on Excel, set priority and see what both machines show.
4) Is the delay in the processing, or in the opening / closing of the source data files?
Maybe a look at the code would offer some suggestions on speed enhancements, so perhaps create a small workbook, with some of the data, and the code and paste it for review.
HTH
rylo
" Page Break " view can play havoc. When Page Break view is on, the print driver re-evaluates the view at the every line of code where print view changes ( such as deleting a row, hiding rows and columns ). Just swith off the Page Break View ( Tools > Options > View > Page Break ticked off ). Page Break View will make print driver re-evaluate the view even if screen update is off.
A V Veerkar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks