Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2013
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Performance issue in windows 7 VBA

    We have some automation code in WORD VBA . The VBA code take data from CSV file and generate the word documents based on the data given in the CSV. CSV file contains nearly lakhs of data. The code which runs under XP takes nearly 15 minutes but in WIn7 64 bit sytem, it takes around 5 hours to complete the process.

    Is there any setting needs to be changed under Windows 7 64 bit system???


    Thanks,
    Udhaya

  2. #2
    New Lounger
    Join Date
    Nov 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Any one know this? I have the same problem...



    link
    Last edited by falloffalot; 2014-05-24 at 10:49.

  3. #3
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Are you running a 32 bit Office edition or a 64 bit?

    It seems that the performance issue results from the fact that VBA runs in a 32 bit process, at least in some cases, so this should be especially bad with 64 bit Office editions.
    Rui
    -------
    R4

Posting Permissions

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