VBA

Resolved · Medium Priority · Version 2003

Tue 18 Nov 2008, 16:31 Delegate 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:23 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Reset Excel toolbars to default settings

If 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.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips