Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2009, 12:59 PM
KramerJ KramerJ is offline What is Application Automation and How can I use it in VBA Windows XP What is Application Automation and How can I use it in VBA Office 2003
Novice
What is Application Automation and How can I use it in VBA
 
Join Date: Mar 2009
Location: Las Vegas, NV
Posts: 5
KramerJ is on a distinguished road
Default 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
Reply With Quote
Reply

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
What is Application Automation and How can I use it in VBA Run Outside application from toolbar button Richard Harison Word 3 12-20-2005 03:22 PM
What is Application Automation and How can I use it in VBA 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 10:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft