Excel- Find Replace problem...

[RMasters]

I am having trouble with programming excel from vb .net.
I need to run a find replace on a spreadsheet that I create in code- creating the .xls is no problem but I am unable to run the find\replace. Can anyone help me.

Many thanks

Rick Masters

 

[T0AD]

I would use something like:

myExelApp.mySheet.myRange.Find( _
        what:= ?xxx? , _
        after:= ?xxx? , _
        LookIn:= xlValues, _
        lookat:= xlWhole, _
        searchorder:= xlByColumns, _
        searchdirection:= xlNext)

Obviously adjust to suit your needs. If it still doesn't work - what error are you getting?

T0AD

There's a thin line between genius, and insanity!

 

[RMasters]

Cheers TOAD, I wasn't defining a range- whoops.

Many thanks