Problems using sheets created in 97 in 2003

[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)

 

[Rob Bovey]

Hi Paul,

Download my code cleaner add-in from the URL below and try running it
on your workbooks. It will often clear up strange errors like this.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Paul Vickers via OfficeKB.com]

Thanks Rob.

Looks like your post was clipped before the mentioned URL? Whats going on
there?

Googled your name and came up with a link to
http://www.cpearson.com/excel/xltools.htm which contains some tools - are
they the ones you mean?

Thanks
Paul

 

[Rob Bovey]

Hi Paul,

http://www.appspro.com/Utilities/CodeCleaner.htm

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Greg J via OfficeKB.com]

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