How do I, in MS Access using VBA, get information from a workbook which I can then put in as a recordset in a table?
I know that excel has an easy workaround for other excel workbooks, and I've read somewhere how to get recordsets from access and input them to excel
Excel to excel:
Dim wb As Workbook
Dim path As String
path = "D:\Documents\etc\Book1.xls"
Application.ScreenUpdating = False
Set wb = Workbooks.Open(Path, True, True)
'do stuff here
Set wb = Nothing
Given the same object control I have in Excel, I should be able to access workbooks and work with that data inside MS Access. I realize now that I have a huge amount of control over all Office components through VBA.
I don't know if its allowed to double post, but I can't edit my first post, so I'll add some of my findings. I write this for others that might also have the same problem.