[RESOLVED] Run Excel Module code from Access...

[strobinson1]

I am opening an excel spreadsheet from Access called test.xls like below. I have a Sub saved in the spreadsheet in Module1 called Test.

How do I run that from Access???

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlWSheet As Excel.Worksheet
 
Set xlApp = New Excel.Application
xlApp.Workbooks.Open ("C:\Test.xls")
xlApp.Visible = True
Set xlBook = xlApp.Workbooks(1)
Set xlWSheet = xlApp.Worksheets(1)
 
'call xlapp.module1.test   ????????
 
 
xlBook.Module1.test