When I convert a database to 7.0, one of the macros in the database fails.
The action is TransferSpreadsheet, and the error is "Couldn't find object
download$accessrange."

"AccessRange" is a valid range name in the spreadsheet which is set through
VBA procedures in Excel.  "Download" is the valid sheet tab name that holds
the described named range.  The name of the spreadsheet is "klrdump.xls"
and is in the same directory as the database.  

According to the Microsoft Knowledgebase, the problem is because of the
ISAM driver truncating at 64 characters.  Clearly, download!accessrange is
not anywhere near 64 characters.

Since the only thing that has changed is the conversion to version 7, I am
suspicious that my problem lies somewhere in that.

Any help would be very much appreciated.  I am on a deadline to get the
database converted by June 1.  Replies can be sent to

Thank you for your help!

And what happens when you explicily specify the range instead of using it's
name??

--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:When I convert a database to 7.0, one of the macros in the database fails.
:The action is TransferSpreadsheet, and the error is "Couldn't find object
:download$accessrange."
:
:"AccessRange" is a valid range name in the spreadsheet which is set through
:VBA procedures in Excel.  "Download" is the valid sheet tab name that holds
:the described named range.  The name of the spreadsheet is "klrdump.xls"
:and is in the same directory as the database.
:
:According to the Microsoft Knowledgebase, the problem is because of the
:ISAM driver truncating at 64 characters.  Clearly, download!accessrange is
:not anywhere near 64 characters.
:
:Since the only thing that has changed is the conversion to version 7, I am
:suspicious that my problem lies somewhere in that.
:
:Any help would be very much appreciated.  I am on a deadline to get the
:database converted by June 1.  Replies can be sent to
:

:
:
:Thank you for your help!
:
:
: