Keep in touch and stay productive with Teams and Office 365, even when you're working remotely. Learn More

Protect Yourself From Tech Support Scams Learn More

Lewis D. Eigen

How can I use an old Microsoft Macro that provides an AutoCorrect Utility?

Thanks to help from the community I was able to find my AutoCorrect files and transfer them to a colleagues computer. Then I wanted to take the next step and create an app that will do this. Before trying to code this, I was informed by a colleague that in around 2000, Microsoft Support created several sets of Macros for different functions. One set was called "Macro9" and it contains an AutoCorrect Utility. I was able to search the bowels of the Internet and actually find a copy of Macro9. However, when I tried to run it, I could not as it was written for 32 bit machines and I have a 64 bit machine. I would like to try that AutoCorrect Utility as I think it will save me a lot of work.

Therefore,

Is there a 64 bit version of Macro9? or

Is there a contemporary version of the AutoCorrect Utility in the Microsoft archives? or

Is there a newly programmed Microsoft AutoCorrect Utility?

If not, what do I have to do with the VBA coding to make it function on a 64 bit machine?

Thanks to one of the community members who responded to an earlier post, there is an existing Macro that allows saving and restoring the ,acl Autocorrect file. However this is very slow and converts the .acl to a Word Document, allows editing, and would restore the Word Document contents back to the .acl. I am looking for a utility that will allow be to append additional autocorrect files to the user's existing .acl file. and hopefully one that works with the existing .acl files and dot convert them back and forth between word and the .acl format.

This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

Question Info

Last updated July 12, 2018 Views 291 Applies to:

Answer

Jay Freedman

MVP
|
Volunteer Moderator

However, what happens when there are two rows with the same labels in the first column but DIFFERENT correction terms? Does the first one get made, and the second ignored since the changed word no longer matches the label. I think I have to not only deduplicate but in the case where there is a first column match

but with different second columns, I think we should ask the user which he wants to keep.

No, it works the other way around: If there are two entries with the same first column but different correction terms in the second column, the macro stores the first one and then overwrites it with the second one. (Your comment about the changed word no longer matching confuses the .acl file's contents with a document's contents: The .acl file can contain only one entry with a given "bad word", so adding another entry with the same "bad word" replaces the first one.) There is no programming in the macro to ignore the second one. It's up to you to remove whichever table row is incorrect.

_____________________________
https://jay-freedman.info

1 person was helped by this reply

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.