![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Feb 2002
Posts: 91
|
Hi Does any one know why word macro runs slower on windows xp machine as compared to windows nt machine? is there any fix for it?
I have one word macro used to take 5 minutes to run now the same macro with the same data takes 14 minutes? I know this is excel board but i am just trying to find answer to this one as i know lot of excel users are word user too? |
|
|
|
|
|
#2 |
|
MrExcel MVP, Administrator
Join Date: Feb 2002
Location: The act or process of locating.
Posts: 13,679
|
I would have to say check out Dreamboat's site: http://www.thewordexpert.com (if she doesn't answer you on this board
_________________ ~*Kristy*~ "Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam." [ This Message was edited by: Von Pookie on 2002-05-06 07:15 ] |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Feb 2002
Posts: 91
|
Thanks. I have posted it on that board too.
This board has lot of traffic. |
|
|
|
|
|
#4 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Allentown, PA
Posts: 2,510
|
Open the doc, open the VB editor (alt-F11), from the Debug menu, choose compile. Save the file, try running your code again. Let me know!
__________________
~Anne Troy |
|
|
|
|
|
#5 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
guys il be extreamly please if dreamboats site answers this, Ok a work VBA script, running slow on different PC's?
Thisis super complex and has all kinds of reasons, i coul write 100 pages on this one. simpl: its down to memory allocations of the PC spec. remember NT is commercial XP is domestic/office so these the difference, not many guys can run NT at home, unless they are techi, even load software is a dog, but its solid. NT built XP remember that, also the 32 bit addressing structures with NT admin technologies account for most. NT is slim and trin POWERing windows to deliver. XP is for amyone, and so is fat lumpy and rough.. i would bet NT wins if seet on same spec PC, NT will sucessfully manage data and resources better than XP will these are guesses as i have never tested this, but sounds spot on to me..
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|