I would like to put together a macro in Excel that looks at an Access table and displays a MsgBox with the last(highest) ID number from said table.

The Excel spreadsheet would be located on end users computers in various locations.

The Access database is located at: "D:\Users\Henry\Desktop\Tracking.accdb" from all computers.
The table name is: "Tbl-Form" and the field name is "ID".

If you can provide pointers to examples, I would appreciate it.

Thanks in advance!!