I'm working on a macro to transpose keys in song sheets.
Sub TransposeKeys()
Dim MusicNotesArray(11) As String
MusicNotesArray(0) = Chr(65) 'A

I'd like to add a subroutine in our global library add-in, in the code
modules, which can be called as part of anyone (of our programmers) form's
initialize event.  This routine uses the keyword "me." to reference the
current form, but the compiler won't allow me to use it in code ...

I would like to create a user form that includes a check
box option to unhighlight all text in a word document,
including the headers and footers.  I'd appreciate any
suggestions.

I have a code that is creating and filling a new document with a template as
base. Herefore the user is requested to enter some specific data in an
userform, activated through a custom toolbarbutton. After code running I
would like to set the focus to this new document but somehow ...

Why can't I use a variable for the count in the GoTo method to delete
merged text?
Basically the thought was to use a DoWhile Loop on a merged document to
go to the beginning of the second page of each section, go back 2 spaces

I have a Word document that utilizes the Microsoft Outlook Object Library.
The problem that I'm running into is the different versions of Outlook.  Our
environment supports three versions; Outlook 2000, Outlook XP, and Outlook
2003.  I was hoping that there is a way to reference the ...

Using the sample code from HELP in the macro:
Sub test()
 MsgBox System.ProfileString("Options", "STARTUP-PATH")
End Sub

I have a combobox in which users can set a language. After updating this
combobox the content of other comboxes is re-filled with data in accordance
to the selected language. This update is however not immediately visible but
only after clicking one of the other comboboxes. I tried ...

Is it possible to start  a program on a server somehow from Word VBA on a
different machine.
The server program would be required to email a few people with a copy of
the document and insert it into another doc as well as create a PDF of the

Hi,
I have some problems with mail merge in Word 2002. In a
merge document in Word 2000 'MailMerge.Execute' will show
the dialogbox Print while the same code in Word 2002 won't

I am using fields in my document such as date and author.
i.e. { DOCPROPERTY Author \* MERGEFORMAT }
I wish to split the author field which is currently "Joe
Bloggs" and create a text field that is an email i.e.

Problem is when performing a mail merge the template, header, and data docs
are opened behind the preview screen.
If they are not manually closed by the user,  the header.doc remains open
and cannot be accessed again.

I have a macro that loads, updates, and save several document templates. I
am using a userform to keep the user apprised of the progress. I would like
to disable the statusbar that displays a progress bar when the file is
saved. ScreenUpdating = False doesn't do it. Is there a way ...

I am very new to word forms and most aspects of VBA. I was asked to create a
form for people to send in information, the form became pretty large over
time (as they do) and my initial method for capturing the data is looking
messy to say the least.

I have made a general file (global template) for users in which I have all
sort of macro's, objects and automated actions. In addition for some users I
have a second file which - if present - will be loaded as gobal template
automatically by the general template.