Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft VBA Training and help » VBA
Resolved · Low Priority · Version Standard
Pritesh has attended:
Excel VBA Intro Intermediate course
Can you link Excel and Access via VBA?
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
|
|
VBA tip:Empty The Clipboard with CutCopyModeAfter each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload: |
TrustScore
4.9
/ 5
2088 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.05 secs.
