I have a worksheet that list employees and what time they start work. I
need to transfer this info into a word userform also. What is the best way
to do this?

1) method is to use ado to extract the data from a closed excel workbook:

http://www.rondebruin.nl/ado.htm

2) automate excel to get the data (this means to open it remotely from
word).

http://support.microsoft.com/kb/302460/en-us
The Office XP Automation Help file is available for download

http://support.microsoft.com/kb/260410/en-us
Microsoft Office 2000 automation Help file is available in the Download
Center

http://support.microsoft.com/?id=167223
Microsoft Office 97 Automation Help File Available on MSL

http://support.microsoft.com/support...aqVBOffice.asp
Frequently Asked Questions about Microsoft Office Automation Using Visual
Basic


http://support.microsoft.com/support...fdevinapps.asp
Programming Office from Within Office

http://support.microsoft.com/support...dev/iisfaq.asp
Integrating Office with IIS FAQ

http://support.microsoft.com/?id=219151
Q219151 - HOWTO: Automate Excel 97 and Excel 2000 from Visual Basic

http://support.microsoft.com/support...automation.asp
Using Automation with Microsoft Excel 97

http://support.microsoft.com/?id=159922
XL97: Using Quit Method May Cause Illegal Operation

http://support.microsoft.com/?id=145770
ACC: Automation Does Not Close Microsoft Excel

http://support.microsoft.com/?id=123859
ACC: Sample OLE Automation for MS Word and MS Excel

http://support.microsoft.com/?id=142476
Q142476 - ACC: Using Automation to Create and Manipulate an Excel Workbook

http://support.microsoft.com/?id=199219
XL2000: Automation Doesn't Release Excel Object from Memory

http://support.microsoft.com/?id=114347
INFO: OLE Automation Objects with GetObject and CreateObject

http://support.microsoft.com/?id=184273
ACC97: How to Use Automation to Create a Microsoft Excel Chart

http://support.microsoft.com/support...151/introd.asp
Office for Windows An Introduction to OLE Automation

http://support.microsoft.com/?id=198703
HOWTO: Automating Excel From Client-Side VBScript


"kcholly" wrote in message
...
I have a worksheet that list employees and what time they start work. I
need to transfer this info into a word userform also. What is the best way
to do this?