S
Sha
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
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