I found the code below on line, which allows me to open an Excel file as an Embedded OLE Object in ACCESS.
Now that I load the Excel file , I want to:
1. be able to manipulate the Excel file from within EXCEL
2. read/loop through the updated data in the Embedded object, and Save the data to a table in my ACCESS database I click on a button.
Private Sub cmdOLEAuto_Click()
On Error GoTo Error_cmdOLEAuto_Click
.Enabled = True
.Locked = False
' Specify what kind of object can appear in the field.
.OLETypeAllowed = acOLEEmbedded
' Class statement for Word document.
.Class = "Excel.Sheet"
' Specify the file to be embedded.
' Type the correct path name.
.SourceDoc = "c:\OLETEST.xls"
' Create the embedded object.
.Action = acOLECreateEmbed
MsgBox CStr(Err) & " " & Err.Description
How can I do this? Thanks in advance