Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft VBA Training and help » VBA
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA
Resolved · Low Priority · Version Standard
ReplyFor upcoming training course dates see: Pricing & availability
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
|
