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.
"(E-Mail Removed)" wrote:
> On Aug 16, 2:57 pm, Joel <J...@discussions.microsoft.com> wrote:
> > Set WordObj = CreateObject("Word.Application")
> > WordObj.Visible = True
> > set Worddoc = WordObj.documents.Add
> >
> >
> >
> > "YoureNotAtHome...@googlemail.com" 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!
>
|
Similar Threads
