J
Joe6Pack
I have a database that needs to pull data from Excel.
Specifically, my Access field should go directly to a
cell in Excel and get that value.
I'm thinking that I use some kind of VBA code to open my
Excel file and assign the cell contents to a variable
which I then use in Access. I think I can find the cell
in Excel using a named range.
I need the exact code, though.
How do I do this?
Thx.
Joe
Specifically, my Access field should go directly to a
cell in Excel and get that value.
I'm thinking that I use some kind of VBA code to open my
Excel file and assign the cell contents to a variable
which I then use in Access. I think I can find the cell
in Excel using a named range.
I need the exact code, though.
How do I do this?
Thx.
Joe