Adding cell locations to a word form
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? |
Adding cell locations to a word form
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? |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com