I ran the code untouched execpt 1 chg ...lcXLS = 'e:\myDays.xls'
still the error persists. bad luck


>I have office2007 on this computer and I just copy pasted the code I sent and ran a few times successfully.
>
>"I even created a new .xls from scratch to test"
>
>Did the first one already exist or generated by the code I sent? Here I only created c:\myFolder before running as is.
>
>Cetin
>
>
>>Posssibly an issue with office 2007?
>>the message I get now is
>>"the class file (USEDRANGE)associated with this field cannot be found-class association cleared"
>>I even created a new .xls from scratch to test.
>>