Search results for query: *

That would work for me too. But I'd still be at a loss as to how to get the AutoText from that one template into another existing template.

Exactly right! These are templates that are specific to a group and I need to make it as simple as possible to run them since the members of the group change. By putting the AutoText and Toolbar in the templates themselves, it doesn't matter who uses them, they will work for everyone. No one...

I don't know if it's possible to bring in the AutoText info via a separate template or how it would be done via a macro since I would need to automate the process. Also, I need to somehow copy a Toolbar from one template to all 200 of the other templates and haven't been able to figure that out...

Sorry, the active document was actually a template that I wanted to somehow copy into. What I am trying to do is copy three new AutoText entries into about 200 existing templates. I'm hoping that there's a way to do this by macro so I don't have to copy these AutoText entries over manually one...

I tried this again and this time the AutoText entries did copy over. Is it possible to put the AutoText entries into the active document instead of creating a new document and putting them there? Cheryl

I tried the code above and couldn't get it to work. Which template is open (the active document)? Why would a new document need to be created from the empty template (the TestTemplate.dot)? I got an error on the code that tries to add the autotext entries. I can't figure out what I am doing...

Oh, and I should specify that I only want to copy 3 specific AutoText entries to the other template. Would it be easier if I copied them to the Normal template first, and then run a macro to copy these 3 AT entries to my other template?

How does this macro work? I'm having a little trouble understanding it. If I am copying the AutoText entries from MySourceTemplate.dot to MyOtherTemplate.dot, how do those two files fit into this macro? They are both existing templates. Cheryl

Oh, yikes!! Really? That's not a good thing! I was hoping I could somehow do it using Organizer and was just not doing it right. Cheryl

Hi, I have three AutoText entries that I need to copy from a global template to a number of other templates. I don't want to insert the AutoText entries into the text of my templates, just copy them into the AutoText list so they are available if needed. Is there a way to do this using VBA...

Is there a way to flag any non-alpha character? Cuz basically, a-z is all that I want to allow. Any help is greatly appreciated! Cheryl

I think I understand Molby's solution, but I'm not sure re Skip and cLFlaVa's solution. For that one, where (and how) would I set up "if KeyAxcii = 0, bring up the form again so user can correct their entry"? Any help is greatly appreciated! Cheryl

I know I can use InStr to see if there's a period or space in a string, but what do I do once I know? I need to determine whether a string contains a period, space, or hyphen. If it does, I need to bring the form back up so the user can retype their entry without the offending character. Can...

Everything works great. The very last thing I want to do is close the Excel application. What would I need for that? Thank you so much for all your help! I couldn't have done it without you!! Cheryl

One of my variables is 9-digit number. When it is inserted in the excel document, it appears as I typed it (E1 = 123456789) above the cells when I click on the cell containing the number, but within the cell itself I see a formula (1.23E+08). How can I reformat the cell as a number through the...

Using the code above, I got a "variable not defined" error on the following: Set acapp = CreateObject("Excel.Application") How do I correct this?

In Word, I have a custom dialog box that will get name and address information from the user, which will then be inserted into the Word document. Is it possible to also insert that same information into an Excel spreadsheet? If so, what would I need to do to get it there? I've never had to do...

Okay, I checked and my template is listed in the global templates loaded list. So I deleted the code I had in Document_Open and Document_New and replaced with the following: Private Sub AutoExec() ' Ensure Enabler Misc toolbar is always enabled CommandBars("Enabler Miscellaneous").Visible =...

Unfortunately, we are not allowed to edit the Normal template. The template that contains the toolbars is also in the Startup folder. So I thought there should be a way to hide the toolbars in the template itself since (like the Normal template) it is always there.

Is there a way to hide a toolbar when Word is opened? I have a template in my Startup folder (Windows NT) which contains 3 toolbars. I only want to see one of those toolbars when Word is first opened. Is there a way to make sure the other 2 toolbars don't automatically appear? It seems like...