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.
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...