View Full Version : How To Open Excel From Access


ninsignares
09-19-2008, 03:28 PM
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
09-19-2008, 04:17 PM
Do you just want to open Excel, open to a new workbook, or do you want to open a specific workbook in Excel?

ajetrumpet
09-19-2008, 08:09 PM
Just opening Excel from Access is like this:dim ObjExcel as New Excel.Application
objexcel.workbooks.open("full path name here")
objexcel.visible = trueIf 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
09-21-2008, 06:19 AM
Shell ("Excel.exe")