R
Ross
How can I run the Access Sub called "ImportExcel" From Excel. My Code
properly opens the Access database but bombs in finding the subroutine called
"Public Sub ImportExcel". Syntax?
'*************************
Sub OpenAccess_FromExcel()
'*************************
Dim A As Object
Set A = CreateObject("Access.Application")
A.Visible = True
A.OpenCurrentDatabase ("C:\Documents and Settings\rcrill\My
Documents\Ref_Code\ImportExcel.mdb")
A.Run "ImportExcel"<---------------------This Fails
A.Quit
End Sub
Many Thanks
Ross
properly opens the Access database but bombs in finding the subroutine called
"Public Sub ImportExcel". Syntax?
'*************************
Sub OpenAccess_FromExcel()
'*************************
Dim A As Object
Set A = CreateObject("Access.Application")
A.Visible = True
A.OpenCurrentDatabase ("C:\Documents and Settings\rcrill\My
Documents\Ref_Code\ImportExcel.mdb")
A.Run "ImportExcel"<---------------------This Fails
A.Quit
End Sub
Many Thanks
Ross