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

why use + when you're concatenating?
use & instead.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Sha wrote:

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

Hi
use the '&' instead of '+' to concatenate strings.

--
Regards
Frank Kabel
Frankfurt, Germany


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/

Hi,
I still get the same message after using &.

Thanks in advance,
bsc.

Attachment filename: errmsg.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=560095
---
Message posted from http://www.ExcelForum.com/

Hi Krank Kabel,
My issue is solved.
I use this code
first set to false
oleExcel.object.application.displayalerts = False

and then set to true.
oleExcel.object.application.displayalerts = True


Thanks,
Sha

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