E
Ed
I posted this quetion in the Access Macros forum, but I am thinking that it
might be more of an Excel issue.
I have an Excel spreadsheet with a range that varies in length. To name the
range, I used the formula:
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),8)
When I call this range, "ImportRange" in my Access 2007 macro (using the
TransferSpreadsheet macro), I get the error, "The Microsoft Access database
engine could not find the object "ImportRange". Make sure the object exists
and that you spell its name and path name correctly."
I know the name and path name are correct, because if I make the named range
a specific range. ex: "=Sheet1!$A$1:$G$10", the import works fine.
Is there an issue with importing a range based on a formula? I am pretty
sure my formula is correct as I tested it with 1 column width in a combo box.
Do you know if this has something to do with the OFFSET formula? Or is it
something with the importing of it into Access?
Thanks for the Assistance,
Ed
might be more of an Excel issue.
I have an Excel spreadsheet with a range that varies in length. To name the
range, I used the formula:
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),8)
When I call this range, "ImportRange" in my Access 2007 macro (using the
TransferSpreadsheet macro), I get the error, "The Microsoft Access database
engine could not find the object "ImportRange". Make sure the object exists
and that you spell its name and path name correctly."
I know the name and path name are correct, because if I make the named range
a specific range. ex: "=Sheet1!$A$1:$G$10", the import works fine.
Is there an issue with importing a range based on a formula? I am pretty
sure my formula is correct as I tested it with 1 column width in a combo box.
Do you know if this has something to do with the OFFSET formula? Or is it
something with the importing of it into Access?
Thanks for the Assistance,
Ed