Fri 28 Mar 2008, 15:20Delegate Pritesh said...
Pritesh has attended:
Excel VBA Intro Intermediate course
VBA
Can you link Excel and Access via VBA?
Tue 8 Apr 2008, 11:42Trainer Roy said...
RE: VBA - Excel - Access integration
You certainly can, and there's scope for some very useful integrations. Things can get complicated, though.
Firstly, you need to have the libraries for both applications loaded. If you are in Excel, this means that you also need the Access and ADODB libraries loaded. Do this through the >Tools >References dialog.
Obviously it depends on what you want to do, but you might like to look at:
-- The Range.CopyFromRecordset method
-- The QueryTable object (a refreshable range that is permanently linked to a Recordset).
/Roy
