hi guys. i am currently working on an human resources information system. i am currently using ms access 2003 and the report form looks like this:




the function of this form, is once a button is clicked, the appropriate report for that button will be generated and will automatically be viewed in ms excel. the problem is that i don't know the VBA code that will perform this function. i read books about access, but unfortunately i can't find the exact answer to my question. so, if anyone could give me some idea on where i can find sample codes for this function, i would very much appreciate it. thanks in advance.

Does this do what you're trying to accomplish?

Dim xlapp As Excel.Application Dim excelFilePath As String
excelFilePath = "d:\my Documents\aaa.xls"
Set xlapp = New Excel.Application xlapp.Visible = True
Set xlapp = New Excel.Application xlapp.Workbooks.Open excelFilePath

Originally Posted by CouponGuy

Does this do what you're trying to accomplish?

Dim xlapp As Excel.Application Dim excelFilePath As String
excelFilePath = "d:\my Documents\aaa.xls"
Set xlapp = New Excel.Application xlapp.Visible = True
Set xlapp = New Excel.Application xlapp.Workbooks.Open excelFilePath

hi. thanks for the reply. i am just a newbie. where should i place this code? i do apologize for the inconvenience.