Have you done Expert 20?

watched them all
I want a VBA Solution as I am disabling for the end user the ribbon.

does any one have the code to read and write to an Excel sheet with VBA?

The easiest way would be with DoCmd.TransferSpreadsheet.

Example:
Dim Filename As String
    
Filename = CurrentProject.Path & "\OrderList.xlsx"
DoCmd.TransferSpreadsheet acExport, , "OrderListQ", Filename, True
FollowHyperlink Filename

Give it a go and explore the different parameters.

Thanks Kevin,

I will need to read and write to pull in information from an order detail spreadsheet and append it to the database on a regular basis, will this work?

its basicly what the import wizzard does, just automated with vba.

Yes. The first parameter is Transfer Type. Set to AcImport to import from Excel. I would recommend importing to a Temp table first so you can check the data first before appending to your main table. In any case remember to make good BACKUPS first.