MS ACCESS - VBA Getting data from excel workbook and put in as records in database
I think the title says most of it.
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.
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...