How To Open Excel From Access

[ninsignares]

hi,
guys i want to open excel from access. I've been trying to do using the execute command in macros but... it doesn't work.

i guess that if i write some code on the vba module i can define an instruction which meets my needs.

Thnx

 

[boblarson]

Do you just want to open Excel, open to a new workbook, or do you want to open a specific workbook in Excel?

 

[ajetrumpet]

Just opening Excel from Access is like this:

dim ObjExcel as New Excel.Application
  objexcel.workbooks.open("full path name here")
    objexcel.visible = true

If you do not get the intellisense dropdown with the first line of code above, that means that you do not have the Excel object library added to your reference List. Tools > References

 

[shamas21]

Shell ("Excel.exe")