Maximum Value in Excel Column From Access (1 Viewer)

[The Archn00b]

Hi I'm using Excel vba for the first time and I'm trying to find the maxium value in the column AI (No. 35) in an Excel spreadsheet FROM Access.

So I've got:

Dim appExcel As Object
Dim datLast As Date

Set appExcel = CreateObject("Excel.Application")

datLast = appExcel.Workbooks("Path").Worksheets("Sheet1").WorksheetFunction.Max(Columns("35"))

Thanks!

 

[namliam]

can you link the sheet as a linked table? Then you can simply query it

 

[The Archn00b]

Yeah I just did that in the end. Good idea.