I can quite easily link in a xls spreadsheet into Access by using a print range, but the info I'm working with now is based on defined named ranges in xls, despite searching I cant find the correct code for the transfer spreadsheet command for the 'range' section. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
transferspreadsheet - bring back defined name ranges in xls.
- Thread starter mikew71
- Start date
- Thread starter
- #2
I figured it out now...I used the "TransferSpreadsheet Method" but was copying the range of cells from the "Define Name" window and pasting it into the "Range" section of the code. That was the problem because it has the cell references prefixed with a "$". Once I removed them from the code, it worked fine.
Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"
Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"
- Status
Similar threads
- Locked
- Question
- Locked
- Question