Replies

It isn’t on any menu by default, but you can put it wherever you want.

Open Tools/Customize, on the Commands tab. Select the All Commands category, and scroll the Commands list to find “Highlight”. Drag it to any menu (Format seems to be a reasonable choice) and drop it where you want it in the dropdown.

It operates in the menu pretty much the same way as in the toolbar — click it to apply the most recently selected color, or click and hold to get the flyout palette of colors.

Some of your AutoCorrect entries (the ones that are formatted) are in Normal.dot, but the rest are in a file with a .ACL extension.

Go to http://www.mvps.org/word/FAQs/Customizatio…Autocorrect.htm to download a template with an AutoCorrect organizer.

Just so happens it’s in the FAQ…

http://www.mvps.org/word/FAQs/TblsFldsFms/…PrintButton.htm

Macros9.dot is available at http://www.mvps.org/word/Downloads/Macros9.zip.

Yes, the GetKeyState function in the Declare statement is an API function, whose code is in User32.dll. The documentation for it is at http://msdn.microsoft.com/library/default….ybinpt_4z51.asp. The values your macro passes to it are the virtual keycodes for the Shift key (decimal 16 = hex 10), the Ctrl key (decimal 17 = hex 11), and the Alt key (decimal 18 = hex 12). [The “And 128” part is to make sure none of the high-order bits are set.]

The original WordBasic macro used GetAsyncKeyState, which is similar to GetKeyState; it’s documented at http://msdn.microsoft.com/library/default….ybinpt_1x0l.asp. To make that macro work, it would need a Declare statement for the API function as well:

Declare Function GetAsyncKeyState Lib “user32” Alias “GetAsyncKeyState” (ByVal vKey As Long) As Integer

When you have the main document set up, with the merge fields in place, but before starting the merge…

Labels are really just a page-sized table, with text and merge fields in the cells. Table cells (not the paragraphs as such) can have vertically centered alignment. The problem is probably that the Mail Merge Wizard tends to put in extra empty paragraphs at the end of each label, which pushes the visible text upward.

Click the Show/Hide button on the toolbar. If you see two paragraph marks (

The “wizard” for Windows Installer is either InstallShield or Wise Installer. Either one is big $$$ and pointless if you’re only going to use it once or a few times. The Windows Installer is so complicated that I wouldn’t advise trying to build a package without assistance.

If you have Visual Studio, it contains a cut-down version of an earlier InstallShield that could do the job. This is a simpler, script-driven program that doesn’t use the Windows Installer engine.

In either case you face a pretty steep learning curve to get something that works, let alone something “slick”. (My day job involves making “slick” installations — it’s a full-time learning experience.) Since you already have a package that works, be happy!

While envelope orientation is supposed to be “sticky”, it seems to be broken for lots of people — I’ve answered the same question a half dozen times in the newsgroups.

What I’ve done to save my sanity is put a global template, Envelope.dot, in the Word startup folder and put this macro in it:

Sub ToolsEnvelopesAndLabels()
Dim dlg As Dialog
Set dlg = Dialogs(wdDialogToolsEnvelopesAndLabels)
With dlg
.DefaultOrientation = wdLeftPortrait
.DefaultFaceUp = True
.Show
End With
Set dlg = Nothing
End Sub

The settings are correct for the Epson Stylus Color 600, which is what I have, too.

Nice catch, Brooke. I don’t have Essbase, so I can’t check, but…

Having found one reserved word used as a parameter name, are you sure there aren’t others?

The trick here is to use a pre-defined bookmark named “Page” (there’s a list of these things in the VBA help under “Predefined Bookmarks”). Try this line of code:

Selection.Bookmarks(“page”).Select

Hi, Randy,

Forgive me if you already know this…

To use the Replace dialog with wildcards, you have to click the More button and check “Use wildcards”. Then you can use the Find and Replace strings Phil showed, and click Replace All.

You can also record a macro while you do this, so repeating it becomes a one-button job. You’ll see in the recorded code that the Selection.Find object has a .MatchWildcards property that is set to True, and the .Wrap property should be set to wdFindStop. The .Find.Execute method takes a Replace parameter that should be set to wdReplaceAll.

Jay

The declaration probably should look like this:

Declare Function apiFindExecutable Lib “shell32.dll” Alias _
“FindExecutableA” (ByVal lpFile As String, ByVal lpDirectory _
As String, ByVal lpResult As String) As Long

There is a possible problem with this approach if the registry key wasn’t set up properly by the app’s installer; see KB article Q140724.

Jay

I posted a couple of macros on one of the MS newsgroups a couple of months ago. Go to http://www.deja.com/home_ps.shtml and search for the post “Re: Scrolling Question” by Jay Freedman on 12/06/2000 in the forum microsoft.public.word.newusers.

Jay