i've got an excel workbook open as readonly and i need to open the same
as writable to write some data.
Set XL_WB = XL_App.Workbooks.Open(FileName:=EXCEL_FILENAME,
ReadOnly:=True)

I'm trying to loop this macro until it doesn't find anymore occurences. I
would very much appreciate any help.
Here's the macro:
   Selection.Find.ClearFormatting

I'm not sure if I'm in the right place, since this is a problem within
a Word macro while trying to open an Excel workbook. Oh yeah, and this
is running on OS X 10.4 with Word X and Excel X.
Here is the code, which I "borrowed":

Anyone can help?  I want to sort my data call from excel file then populate
to word combobox. I need to capture the column 1 ID but display Column 2 data.
How to sort the data in alphabetical order?
My script as below:

I'm trying to take a merged document, have the VB macro chop each range
as a separate file and save it as a filename specified by the first
field.  For instance, if the first line of text (field is called
"story") in the merged range appears as "car", I would want the file

i'm searching excel for some text typed in word using vba.
it works in english, but not when the text is in the language i'm
working on. its DI named Divehi in the windows language settings
environment.

When we create a new document from a template, some fields are created. From
these fields the filename for the document can be determined. When Save is
selected
the first time it seems that the Title is used as a starting point. However

In Word 2003, I've created a macro to select certain trays for paper type,
such as bond, draft, etc.  My firm has multiple different printers, and I'd
like to have the macro automatically select a certain tray BASED on the
active printer.  Is there an IF statement, for example, ...

My name is Vincent,  
In the past, I created tests and quizzes using the "Forms" from Word with
the hope that my boss will agree to have our testing online instead of doing
paper based.  Unfortunately I had a lot of resistance from my coworkers so my

I'm trying to set up some document variables whose values appear in the text
but also in headers and footers, and that I can easily change. It all seems
more difficult than it should be. Detecting whether there's already a
variable by a certain name should be easier. But how do I ...

I'm trying to figure out something that's pretty easy, but I'm semi
brain dead at this point and can't see how:
I have a function that works fine and inserts a new page at the end of
the current section, then adds a couple paragraphs, something like

I need a macro that will look for a repeating string of characters and on
the next line enter a page break.  For ex, look for "00DA" and enter a page
break after it.
This will allow me to run the macro and not have to enter hundreds of page

I have a userform on which there are a number of comboboxes, one for Day of
week, one for date, one for Month and one for Year. On initialising the
dialog, I am looking to populate each combobox with the day and date 14 days
from opening the document, i.e 14 days drom today.

I'm trying to call a macro based on the input to a text form field. When run
on exit, if the formfield says sterling then run SterlingAccount. If it says
anything else then run CurrencyAccount. The code below is what I've adapted
from calling a macro from a dropdown list. ...

I have cross referenced a bookmark to reflect the bookmarked text in a
header.  The bookmark is in a cell in a table.  I need only the
bookmarked text ie not the table cell to display in the header.  Each
time I update fields the single cell table reappears in the header.