Thread: What is Application Automation and How can I use it in VBA
View Single Post
 
Old 03-30-2009, 12:59 PM
KramerJ KramerJ is offline Windows XP Office 2003
Novice
  
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