good morning--closing excel in VB

[hateexcel]

so, i open excel from access with the following macro:
Private Sub RunExcel()

Dim xlApp, xlBook As Object

Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add("q:ma_gruppenstudentenarberabensprotocolreading.xls")

xlApp.visible = True

xlApp.Application.Run "import"


Set xlApp = Nothing
Set xlBook = Nothing

Call TextDateiEinlesen

End Sub

where textdateieinlessen is a access macro.

how can i make excel close before the call command. is there a command i can put in the excel macro to close excel? or is there a command i can put in the above macro. eg:
xlApp.Close
which would be good but doesnt work

 

[Andrew Poulsom]

Try:

xlApp.Quit

 

[hateexcel]

unfortunately, that doesnt work.
(i put it in just before the call command)

 

[Mudface]

Try it before you set xlapp to nothing.

 

[Ian Mac]

On 2002-10-02 04:04, hateexcel wrote:
unfortunately, that doesnt work.
(i put it in just before the call command)

I'm assuming the thing your calling isn't in Excel.

I've just used:

xlApp.Quit
Set xlApp = Nothing
Set xlBook = Nothing

Call cmbEmail_Click

and this works fine for me.