I created a script using Word VBA.

[dfhainsd]

I created a script using Word VBA. The script includes code to extract ranges from the document as well as save the document in a different directory. The orginal document is removed using the KILL function.

The process was fast when I first started using the Macro, however it has become extremely slow. Even when I open a new document, Word hesitates for about 20 seconds while it "thinks" then It works fine. This hesitation is also occuring with excel.

I have
1. Installed all the lastest patches and service releases from Microsoft site.
2. Used Microsoft Setup and did a REPAIR
3. Uninstalled the complete installation of Microsoft office and reinstalled.
4. Reinstalled Windows 98 on top of the existing installation.
5. Virus scanned using the latest all files on my system.

I really dont know what could be causing this. Any suggestions would be great.

Thanks,

Domonic Hammes
domonic@dfha.com

 

[Dreamboat]

Try renaming your normal.dot file to abnormal.dot. Let us know.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[dfhainsd]

Dreamboat;

Renamed it and it does not effect the opening. Forgot to mention - If i open word, the blank document is fine. I select File Open and select a document and the problem happens.

Any other suggestions?

domonic

 

[Dreamboat]

Okay. Many questions/confirmations:

Office 2000, right? Did you use Eraser 2000 when you uninstalled? (See technet or ask me)

Where is the script? Is this VBA code? Stored in normal.dot or where? Is it used on all docs or problems just happened to start occurring after you created this code?

Script is not usually used when describing code in Word, so I want to be sure...

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[dfhainsd]

Yes office 2000, I used Add/Remove in Control Panel

It is VB code contained in a specific documents. It is not in any of the documents I am opening (although they open as slowly as the ones without the code)

I use the code in word to rename files and move to another directory. I have been using the code on about 18000 files over the last few weeks. I have about 14000 left to go. The code ran great for a while and lately the documents have been opening real slow. Orginally I was going through word files at a rate of about 1 every 3 seconds, now it opens fine, hesitates for 15-20 seconds, starts to save, then closes. It hesitates for a about 5 seconds and then opens next file.

wow

Whats your thoughts Dreamboat?

domonic
domonic@dfha.com

 

[Dreamboat]

Have you cleaned up your hard drive? I'm a firm believer, so if you didn't specifically for this problem, humor me.

Close all programs and do a find for:

*.tmp,~*.*,*.chk

on the entire C: drive. Hey, maybe this deal is making temp files and you're not aware and they're eating up your resources. Then, make sure your C:\windows\temp folder is completely empty (programs and all). Okay, so delete all those, empty recycle bin (but not if you don't trust me), run scandisk, and defrag. When you're moving/making/creatin/deletin files from a hard drive at the rate you're going, you need to defrag it.

Do that. Then we'll talk. K?
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[dfhainsd]

Dreamboat;

I have tried everything you suggested. Even picked up a copy of Diskkeeper - which is considered a more effective defragger. I think I will reload Windows 98 from scratch and see what happens unless you have another suggestion.

I have continued processing files on a different machine. It's working fine after about 5000 files

Let me know if you have other ideas.

Thanks for the help.

Domonic

 

[Dreamboat]

Well, let's try this first:

Go into Outlook and make sure that you didn't somehow turn journaling on. Just click on the journal and a box should come up. Make sure no checkmarks.

If no good, try:

Start-Run and type regedit and hit enter.

Go to this folder:

hkey_current_user\software\microsoft\office\9.0\word

and rename it to OldWord

See if that helps.

If not, go here

http://support.microsoft.com/support/kb/articles/Q219/4/23.ASP

and get Eraser 2000 and completely remove MS Office, then reinstall. If that doesn't work, then I give you my blessings to reinstall the OS. Not that you need my blessings. I just hate it when someone says, "so I reinstalled..." when they didn't need to.

Good luck and let me know!
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[dfhainsd]

Dreamboat;

Depressing but true...

I completely removed office 2000, had a hard time making happen, It kept on telling me that SP1 was installed. Well after I finally got it to completely remove. I reinstall and the problem was still there.

As a side issue...is it possible for this to be cause by the number of word documents on the system. I ahve about 35000 word documents. some of the directories contain more than 2000 word documents. Could this be the source?

Thanks for all your help.. Saturday is the big day...reinstall Windows98

Domonic

 

[Dreamboat]

Geeze, Domonic. Why so many?

Have you thought about Winzipping them into their own winzip files?
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[dfhainsd]

The project I am working on has that many word documents. I can switch the files to a different computer and see if that helps - if you think that it could be the problem.

Domonic

 

[Dreamboat]

I've NEVER heard of that many. I don't know.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[dfhainsd]

Dreamboat;

I thought I would let ya know...

I reinstalled windows..While deleting the old Window's directory...the Recent directory took almost 30 min to delete. I guess just using the properties on the task bar does not clear all recent files. I monitored the recent file and was able to complete the indexing of the Word files

Thanks for all the help!!!!

Domonic
domonic@dfha.com

 

[Dreamboat]

Anytime. Glad you were able to resolve it!
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word