Open a ms access report from a excel macro

[Malc8179]

Hi Guys

Has anbody an idea how to open a ms access report from a bit of code i need to write in excel

 

[JerryKlmns]

Take a look on Automation with Microsoft Access

Dim objAccess As Object 'Access.Application

Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase FullPathAndNameOfDatabase
objAccess.DoCmd.OpenReport ....

objAccess.Quit
Set objAccess = Nothing
[code]

 

[Malc8179]

Thanks

this code sends it to a printer (great) but i also need to view it

 

[JerryKlmns]

Malc8179

This sends it to the printer
docmd.OpenReport "YourReportName", acViewNormal

and this to your screen for preview
docmd.OpenReport "YourReportName",acViewPreview