Call Acess db Reports from Excel macro

[George]

Hi there again, I need help with calling an specific
report from a specific database using macro. Any help will
be appreciated

 

[Kalle]

You get as much help as you can get.
So this is very little help according to your very undetailed question.

 

[George]

I`ll try to be more specific, I am creating a macro in an
Excel file, this macro should ask the user what report
from a specific Access database he wants to analyze in the
excel file. I already have the form to ask the user what
reports he wants to see, now I need to create a code that
retrieves whatever report from the specific database.

 

[Guest]

The easies way is to use SQL to retrieve data from ACCESS. However, as far as I am aware, you can qery TABLES and QUERIES only i.e. not REPORTS.

 

[Dick Kusleika]

George

With Access properly referenced (VBE - Tools - References), use a sub like
this

Sub AnalyzeReport()

Dim acApp As Access.Application

Set acApp = New Access.Application

acApp.OpenCurrentDatabase "C:\Dick\db1.mdb"

acApp.DoCmd.OutputTo acOutputReport, "rptTable 1", _
acFormatXLS, "C:\Dick\Tester\MyReportl.xls", True

acApp.Quit

Set acApp = Nothing

End Sub

Replace rptTable 1 in the OutputTo arguments with the name of the report
selected.