Hi,
I run reports in Excel from Visual Basic. It was working

fine when it was developed on NT Machine having Excel 2000. BUt

now when the application is moved onto XP Machine I have Excel

2002. Now when I run on XP Machine I get a message
"Microsoft Excel cannot find any data to replace.Check if your

search formatting and criteria are defined correctly.If you are

sure that matching data exists in this workbook,it may be on a

protected sheet.Excel cannot replace data on a protected

workseet".
The lines where I get this error message in code is
oleExcel.object.worksheets(XLS_SHEET_NAME).range(" A1:" +

"Z1539").Replace NULL_VALUE, ""

oleExcel.object.worksheets(XLS_SHEET_NAME).range(" AA1:" +

"AZ1539").Replace NULL_VALUE, ""

Null_value is a variable declared and has the value
Private Const NULL_VALUE = -9988998

So please let me know why is thsi happening on a XP Machine

having Excel 2002.
Do I need to do any changes programatically. Please guide me.

Note: I get this message and then when I click the OK button

the report runs fine.It doesn't hang anywhere. But I donot want

to get this message in between.

Thanks in advance for your time.
bsc

--
Message posted from http://www.ExcelForum.com