Consulting

Results 1 to 8 of 8

Thread: Memory Read error

  1. #1
    VBAX Tutor lynnnow's Avatar
    Joined
    Jan 2005
    Location
    Mumbai, Maharashtra, India
    Posts
    299
    Location

    Memory Read error

    Hi,

    I used a code to get the word count and page count and export it to Excel, however, when I run the code and exit Word, a memory read error occurs.

    Can anybody shed light on this subject?

    I'm using Office 97 with Win 2k.

    Thanks.

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    I'm not really sure what would cause the memory read error. It could be a problem with your PC or with Word itself.

    I would try the Detect and Repair feature first (Although that never has fixed any problems for me). Then try uninstalling office and delete any Office folders left behind. Then do a fresh install.

    And if possible you should upgrade to at least Office 2000 since 97 is buggy on a good day.

  3. #3
    VBAX Tutor lynnnow's Avatar
    Joined
    Jan 2005
    Location
    Mumbai, Maharashtra, India
    Posts
    299
    Location
    Hi,

    Thanks for the suggestion, however, it is company policy that we have 97 installed till an upgrade is advised. Secondly, getting the Helpdesk to actually uninstall and reinstall is like pulling teeth. Thanks a lot for the suggestion though. However, where is the detect and repair option. I checked the control panel, the word help file, but there is no such option, so please point me in the right direction again.

    Take care

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Try the Help menu in Word from the Worksheet Menu Bar.

  5. #5
    VBAX Mentor
    Joined
    Sep 2004
    Location
    Nashua, NH, USA
    Posts
    489
    Location
    Quote Originally Posted by DRJ
    Try the Help menu in Word from the Worksheet Menu Bar.
    I do not believe that office 97 has detect and repair, at least I could not find it in Word 97 the other day.

  6. #6
    VBAX Mentor
    Joined
    Sep 2004
    Location
    Nashua, NH, USA
    Posts
    489
    Location
    Quote Originally Posted by lynnnow
    Hi,

    Thanks for the suggestion, however, it is company policy that we have 97 installed till an upgrade is advised. Secondly, getting the Helpdesk to actually uninstall and reinstall is like pulling teeth. Thanks a lot for the suggestion though. However, where is the detect and repair option. I checked the control panel, the word help file, but there is no such option, so please point me in the right direction again.

    Take care
    You should inform your company that:

    1. Office 97 is less robust than later versions
    2. Office 97 VBA is brain dead compared with later versions.
    3. You can program more effectively using the VBA in Office 2000, and later, if only because of modeless userforms, more application events, Split/Replace/Join string functions, etc.
    4. Newer 3rd party apps that hook into Office likely do better with later versions of VBA.

    Indeed, unless a client asks me to do so, I will no longer go out of my way to accommodate Word 97 in VB/VBA code.

  7. #7
    VBAX Tutor lynnnow's Avatar
    Joined
    Jan 2005
    Location
    Mumbai, Maharashtra, India
    Posts
    299
    Location
    Hi Howard,

    As I stated earlier that it is company policy, the reason for Office 97 ruling in our office and making my learning experience a hell is because the client uses Citrix to import these documents and since our management is a dead head in all this technology stuff, they will opt following what the client tells them to do. I sure hope that the client upgrades to office 2000 and makes it better for coding, but I don't see that happening in the near future.

  8. #8
    VBAX Mentor
    Joined
    Sep 2004
    Location
    Nashua, NH, USA
    Posts
    489
    Location
    Quote Originally Posted by lynnnow
    Hi Howard,

    As I stated earlier that it is company policy, the reason for Office 97 ruling in our office and making my learning experience a hell is because the client uses Citrix to import these documents and since our management is a dead head in all this technology stuff, they will opt following what the client tells them to do. I sure hope that the client upgrades to office 2000 and makes it better for coding, but I don't see that happening in the near future.
    Yes, the Client is ALWAYS right.
    But, and I do have a big BUTT, your organization should use all the Word versions so they can handle whatever clients want,

    I will program in Office 97 if a Client wishes, but I will no longer go out of my way in any of my own code to assure support for Office 97.

    Heck, just being able to use the DocumentBeforeClose event is sufficient reason for me to not support Word 97 in my own code,

Posting Permissions

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