Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    buy new pc: run Excel macro

    Hi all. i was thinking to buy new pc just to install Windows,Microsoft Office 2002 and run two Excel files only. one Excel files contains macros about 10k KB storage and another file contains data running macros from the first file about 50k KB storage. and i was thinking to save cost to buy such pcs cause only run macros all day long.

    my question is, what is important and what is not important in a pc to run macros ? (and i can drop or lower the cost of what is not important).
    any recomendation for:
    .proceessor?
    .memory?
    .HDD?

    criteria: varies brands for items above to consider and their prices.
    pc objective: run good macros (i am sure it is 'fast').
    user objective: to minimise cost.

    any special hint to take note?
    (or just scrap all above and take something else in?)
    Thanks.

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: buy new pc: run Excel macro

    More memory and faster processor will make things run faster, but how much benefit depends on what the macros are doing.
    More disk space does not affect performance, again, need depends on what macros do.

    Another factor is the efficiency of the macros.
    Excel macros can be very inefficient. I recoded a client's macros and reduced run time by 99.2% and there's likely still more room for impriovement.
    More memory and faster processor ovedrcomes some of the inefficiences, but if a macro is to run ALL dat, one needs to assure that it is efficiently written.

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: buy new pc: run Excel macro

    I have moved the replies to this thread to the VB/VBA board, as we were discussing the relative merits of recorded vs hand crafted VBA code. They can now be found at <post#=426275>post 426275</post#>.

    StuartR

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •