#1
|
|||
|
|||
What is Application Automation and How can I use it in VBA
How do I use Applicaion Automation in VBA to access and work with data in Excel worksheets from MS/Access. Could someone provide a code sample of how I can use Application Automation to import (I can use the DoCmd,,Spreadsheet function) data from multiple worksheets within a workbook. I would prefer to work with multiple ranges if that's possible.
Many thanks and TIA |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
COM Automation Errors | ivanm | Word | 0 | 03-23-2009 07:02 PM |
Application.Caller | pankajkankaria | Excel | 0 | 03-18-2009 11:48 AM |
Excel 2003 will not terminate with application.quit | Peter Schellenbach | Excel | 12 | 03-14-2006 05:28 PM |
Run Outside application from toolbar button | Richard Harison | Word | 3 | 12-20-2005 03:22 PM |
access runtime application will not install | markjean | Office | 1 | 12-06-2005 02:15 AM |