range command issue?

I have a macro in excel that works.

Sub jim()

Range("$A$1").CurrentRegion.Select    
    
    Selection.RowHeight = 13
    Selection.Font.Bold = True

…etc.

If I open a csv and run this macro it selects the seen data and then later does stuff to it.

*****

when i try to turn this into a program i get an error.

oExcel = CreateObject([Excel.Application])
oExcel.Visible = .T.

osheet = oexcel.workbooks.open("K:\wellcarestuff\All Data Files\test.xls")


      Range("$A$1").CurrentRegion.Select  ' <<<===   get an error here?

would appreciate any ideas on what i'm doing wrong.

thanks.

jim

Moderator's note: Please read our rules, #3 says code tags are required. I have added them for you because you are a new user. --6StringJazzer