A sheet name cannot contain a minus sign. I suspect in the other
workbook the minus sign was not part of a string name but was
interpreted as a real minus sign and you were perfrom a subtraction.
for example
A = 5
B = 3
A - B = 2
Which is not the same as the string
"A - B"
You code has double quotes around the variable s="Brazil-008.ord" which
makes it a string.
--
joel
------------------------------------------------------------------------
joel's Profile:
http://www.thecodecage.com/forumz/member.php?u=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=206229
http://www.thecodecage.com/forumz