98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
VBA
Resolved · Medium Priority · Version 2003
Tue 18 Nov 2008, 16:31Delegate Donna said...
Donna has attended:
Excel VBA Intro Intermediate course
VBA
How do I link VBA in Excel to other Applications like Excel i.e. tell VBA in Excel to go to Access and pull a certain dataset into excel
Wed 21 Jan 2009, 14:23Trainer Laura said...
RE: VBA
Hi Donna
Thank you for your question.
Your question has two parts. To control another application you need to create an application object.
Please let me know how you get on.
Sub WordExample()
'Opens word and creates a new document
Dim appWord As Object
Set appWord = CreateObject("Word.Application")
appWord.Visible = True
appWord.Documents.Add
End Sub
The second part is regardng accessing data from an access database and that could be done in many different ways. One of the easiest is to record using a database query and would not require you to launch access.
I hope that helps. Regards
Laura GB
Tue 27 Jan 2009: Automatically marked as resolved.
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. |
Excel tip:Reset Excel toolbars to default settingsIf you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults. |
