View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_996_] joel[_996_] is offline
external usenet poster
 
Posts: 1
Default Problem with - sign in sheet name??


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