ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can Access stored procedures be executed from within Excel (https://www.excelbanter.com/excel-programming/346073-can-access-stored-procedures-executed-within-excel.html)

rmcompute

Can Access stored procedures be executed from within Excel
 
I set up the code listed below to attempt to execute an Access stored
procedure from within Excel. It seems that this code only can execute
queries. Is there another method which can execute the subroutine ?

Sub ExecuteAccessSub()
Dim dbs As Database
Dim strFile As String
Set dbs = OpenDatabase("AccessNotes.mdb")
dbs.Execute ("SubAccessProg")
End Sub



All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com