Simply record a macro while going to the menu

Insert - Object - from file

the choose either line to file or show as ICON (if you want to actually put
the file into the worksheet).

Here is my recorded macro
ActiveSheet.OLEObjects.Add(Filename:="C:\TEMP\subm issionx.mdb",
Link:=False _
, DisplayAsIcon:=True, IconFileName:= _
"""C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE""
/NOSTARTUP ""%1""" _
, IconIndex:=0, IconLabel:="C:\TEMP\submissionx.mdb").Select


Usualy I edit it like this

set obj = ActiveSheet.OLEObjects.Add( _
Filename:="C:\TEMP\submissionx.mdb", _
Link:=False, _
DisplayAsIcon:=True, _
IconFileName:="""C:\Program Files\Microsoft Office\Office10" & _
"\MSACCESS.EXE"" /NOSTARTUP ""%1""", _
IconIndex:=0, _
IconLabel:="C:\TEMP\submissionx.mdb")

Notice I removed the select from the end and put "set obj = " at the
beginning.

"Webtechie" wrote:

I need to create a master spreadsheet with dashboard qualities.

I will embed about 5 charts on a sheet using VBA. Now next to the embedded
chart, I'd like to show an Access report.

I don't want to export an Access report to an spreadsheet. I'd like to show
the access report in a part of a spreadsheet.

Does anyone know how to embed an Access report into a userform or embed it
in a spreadsheet? Using VBA?

Thanks,

Tony