Open/Close excel in Access

[scrappe7]

hi out there,

I have a macro that runs a query and then sends a lsit of names to a dumby excel file. Then on my main excel file i reference the list of names from the query to a column and use that as the source for my list box.

Here are the parts i need help on:
1) I know how to run the query and export the data to the dumby sheet

2) How can i make the next step of this macro to be to open up a desired excel file? Where would i enter it.? I am thinking there is a commmand line in module that i can use. This will be the main file that the dumby file gets refernced to.

3) I then need to close the dummy file as the next step of the macro. If there's a command to open a file there should be on to close a file as well??


Does anyone out there know the syntax to open and close excel files from access?? Your help is greatly appreciated. Also, please be very detailedin your explanation because i am a VB newbie. Thank you again!!!

Ed

 

[Databaseguy]

Here's the basics. Search the Microsoft Knowledge base or MSDN for "Automation".

Dim objExcel As Excel.Application
Set objExcel = New Excel.Application
'Make it visible (default is invisible) and add a new workbook
With objExcel
.Visible = True
.Workbooks.Add
End With