I've been writing a word macro that takes 2 excel files and merges
them into 2 different documents.
What I am trying to do is to count the Records being merged and
display them in a message box.

The statement for MATLAB invokes a macro that has been
defined within the active Excel spreadsheet file
is:handle.ExecuteExcel4Macro('!macroname()'),but I can't
find the correct statement for MATLAB invokes a macro that

Hello
In a bid for Sustainable working (reducing my companies carbon footprint)
i'm trying to limit the amount of printing done on my network.
i can block printing using VBA in Excel but i'm scoobied about how to do it

Kinda new to writing subroutines within VBA.  I didn't realize that all
the module-level variables declared in the body of the procedure are not
available to you in the SUB.  I guess I have to pass any that are needed
in the SUB, as arguments?  Is there another technique?

Can I embed a SQL cursor inside my VBA script?  I need to grab some
values from a SQL table and have those available to me as VBA variables.  
Thanks.

Hello!
My Problem is, that i have to fill a Word Document(Template) with DataBase
Data...
I Found out how to set Bookmarks in the Document and correctly fill them with

I have recorded a macro which inserts header & footer & address Autotext
entries but when I try to run it bombs on the first line & comes up with
error 'Run time error 5941 Requested member of the collection does not exist'
My autotext entries are CIMSHeader, CIMSFooter & ...

I have an application I'm writing that needs to move text from one
place in a word doc to another. A simple enough process but it's
proving to be difficult to get just right. Right now I have it
*working* using cut and paste. The only problem with this is that, as

Program runs fine from a removable usb drive. when run from my hard drive it
says locked for editing.   Would like to know why it is locked on my drive
but not locked on removable drive.
Thanks

In my office, I have several people who setup their MS Word 2003 to
show units as inches instead of points, but oftentimes it switched to
points.  Is there a way, maybe using the AutoOpen macro, to ensure a
file opens using inches instead of points?  Thanks.

A word document is ceasing to respond to mouse commands after an error
handler displays a msgbox.  Cursor commands and keyboard still work in
the document.  The mouse still works on toolbars and menus but not the
scroll bars.  Very strange.  Happens regurly with this template.

How to deduce date in words in Word? For example: July 10, 2007 should
be as "Tenth of July two thousand seventh year"

I would like to create a modified version of the "print" button to the Quick
Access Toolbar in MS Word 2007 - where the modified button will trigger an
macro that I set up to print to a different tray in my printer.
What is the default location of these graphic files for the ...

Can someone advise me why the following code when run produces the footer in
the order:
Date        Page Number        Created by
When the order of the code is Created By,  Page Number and Date

i need a VBA code to Extract word document content and save in MS Access.
Regards
Raju A