It's possible if you open the workbook in an instance of Excel created in Access:
Const ExcelPath As String = "U:\Access\test.xls"
Dim Benchmarks As DAO.Recordset
Set Benchmarks = CurrentDb.OpenRecordset("Tbl_Orders")
Dim XLBook As Excel.Workbook
Dim Xl As Excel.Application
Dim XLsheet As Excel.Worksheet
Set Xl = CreateObject("Excel.Application")
Set XLBook = Xl.Workbooks.Open(ExcelPath)
Set XLsheet = XLBook.Sheets("User_Input")
Your code worked, however...
I should have mentioned that the workbook I'm trying to manipulate is not saved, so there is no existing file path. The excel file in question is generated through a website upon the user's request.
Maybe I need to look into importing the workbook into a temporary table and then pull everything from there.