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?