Hello,
I have an access program connected to a large database. The access program calls an excel file and performs some calculations and saves the results in the access database.
I am trying to automate this process and was wondering how I can call from within the access vba, a vba-routine that is connected to the excel file.
The following vba code inside Access opens the excel file
I would like to call the excel subroutine "MyRoutine" from inside the same block of Access code. Is this possible?
Thank you,
Lanox
Bookmarks