In my application, I open excel worksheet via Access Form and show data in pivot table and draw chart based on data in the pivot table.
Though it seems to be working, I do get Automation Error in Access subroutine.
I try to close the excel application by using the following code
objExcel.Quit
Set objExcel = Nothing
Set objsheet = Nothing
Appreciate any help on this
Thank you
Mahesh
Though it seems to be working, I do get Automation Error in Access subroutine.
I try to close the excel application by using the following code
objExcel.Quit
Set objExcel = Nothing
Set objsheet = Nothing
Appreciate any help on this
Thank you
Mahesh