User inputs data to Workbook1, processes it, clears it ready for the
next lot of data. Several users using 'Read Only' versions of Wb1 at
once.

The process is: Open a Worddoc, put some data from Wb1 in it, print
it, open a 2nd Worddoc, put some data from Wb1 in it, print it, put
some data from Wb1 in Workbook2, save Wb2.

The Worddocs don't need to be saved or stored anywhere (Wd1 will be
scanned (after it's been signed), Wd2 will be indexed to a DIPS file -
neither of which actions will be part of this process). Workbook2
doesn't need to be opened - can data be entered in a wb when it's
closed or would I need to make Wb2 a shared wb and get all users to
keep it open? Also - it will be receiving data from several users at
once and I want the data to go to 'next vacant row'. Would there be a
danger of any kind of 'clash'?

Can anybody give me a start?

Set WordObj = CreateObject("Word.Application")
WordObj.Visible = True
set Worddoc = WordObj.documents.Add


" wrote:

User inputs data to Workbook1, processes it, clears it ready for the
next lot of data. Several users using 'Read Only' versions of Wb1 at
once.

The process is: Open a Worddoc, put some data from Wb1 in it, print
it, open a 2nd Worddoc, put some data from Wb1 in it, print it, put
some data from Wb1 in Workbook2, save Wb2.

The Worddocs don't need to be saved or stored anywhere (Wd1 will be
scanned (after it's been signed), Wd2 will be indexed to a DIPS file -
neither of which actions will be part of this process). Workbook2
doesn't need to be opened - can data be entered in a wb when it's
closed or would I need to make Wb2 a shared wb and get all users to
keep it open? Also - it will be receiving data from several users at
once and I want the data to go to 'next vacant row'. Would there be a
danger of any kind of 'clash'?

Can anybody give me a start?

On Aug 16, 2:57*pm, Joel wrote:
Set WordObj = CreateObject("Word.Application")
WordObj.Visible = True
set Worddoc = WordObj.documents.Add



" wrote:
User inputs data to Workbook1, processes it, clears it ready for the
next lot of data. *Several users using 'Read Only' versions of Wb1 at
once.

The process is: Open a Worddoc, put some data from Wb1 in it, print
it, open a 2nd Worddoc, put some data from Wb1 in it, print it, put
some data from Wb1 in Workbook2, save Wb2.

The Worddocs don't need to be saved or stored anywhere (Wd1 will be
scanned (after it's been signed), Wd2 will be indexed to a DIPS file -
neither of which actions will be part of this process). *Workbook2
doesn't need to be opened - can data be entered in a wb when it's
closed or would I need to make Wb2 a shared wb and get all users to
keep it open? *Also - it will be receiving data from several users at
once and I want the data to go to 'next vacant row'. *Would there be a
danger of any kind of 'clash'?

Can anybody give me a start?- Hide quoted text -

- Show quoted text -

Thanks, Joel, I think I can get going now - but I may need to come
back to you!

Be careful the macro code for word isn't exactly the same as Excel. You can
try recording a macro in Word to do the tasks you want, but they may need
minor changes before they work in Excel. Also a table in word is addressed a
little diferetly then a spreadsheet in excel. Sometimes adding a parenthesis
or removing a parenthesis can get thing to work. Be prepare to experiment.

" wrote:

On Aug 16, 2:57 pm, Joel wrote:
Set WordObj = CreateObject("Word.Application")
WordObj.Visible = True
set Worddoc = WordObj.documents.Add



" wrote:
User inputs data to Workbook1, processes it, clears it ready for the
next lot of data. Several users using 'Read Only' versions of Wb1 at
once.

The process is: Open a Worddoc, put some data from Wb1 in it, print
it, open a 2nd Worddoc, put some data from Wb1 in it, print it, put
some data from Wb1 in Workbook2, save Wb2.

The Worddocs don't need to be saved or stored anywhere (Wd1 will be
scanned (after it's been signed), Wd2 will be indexed to a DIPS file -
neither of which actions will be part of this process). Workbook2
doesn't need to be opened - can data be entered in a wb when it's
closed or would I need to make Wb2 a shared wb and get all users to
keep it open? Also - it will be receiving data from several users at
once and I want the data to go to 'next vacant row'. Would there be a
danger of any kind of 'clash'?

Can anybody give me a start?- Hide quoted text -

- Show quoted text -

Thanks, Joel, I think I can get going now - but I may need to come
back to you!