Problems using sheets created in 97 in 2003

  • Thread starter Thread starter Paul Vickers via OfficeKB.com
  • Start date Start date
P

Paul Vickers via OfficeKB.com

Using a number of spreadsheets that were created in 97 in 2003. All of
them have fairly complex macros.

Returning intermittent errors when opened and run in 2003.

Have googled for some answers - but as much as there are references to the
specific error codes, -nothing specific about moving to 2003 from 97.
The spreadsheets + macros work fine in 97.

Here are some chunks of the code, and the associated errors.

Sub AccountClearFilterArea()
Range("B7:I7").Select
Selection.ClearContents
Range("A1").Select
End Sub

Run-time error ?-2147417848 (80010108)?: Method ?ClearContents? of object
Range? failed



Sub SoldLogLastWeeksSales()
Dim tmp1, tmp2 As String
tmp1 = Range("SoldLogLastWeeksDate").Text
tmp1 = ">" + tmp1
Selection.AutoFilter Field:=1, Criteria1:=tmp1,
Operator:=xlAnd
End Sub

Automation error (Error 440)
 
Hi
Unfortunately the code cleaner did not fix my problem. It looks like I will
have to start from scratch and recreate the spreadsheets from the beginning
in Excel 2003 unless someone can help me please.

Thanks!

Greg J
 
Back
Top