What is Application Automation and How can I use it in VBA

		Microsoft Office Forums > Microsoft Excel > Excel
What is Application Automation and How can I use it in VBA

FAQ

Thread Tools

Display Modes

03-30-2009, 12:59 PM

KramerJ

Windows XP What is Application Automation and How can I use it in VBA

Office 2003

Novice

Join Date: Mar 2009

Location: Las Vegas, NV

Posts: 5

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:56 AM.