>>>I had similar problems trying to save excel file with & and long file names. Tried () instead and worked. Your example looks funny though, if you're enclosing & within quotes. HTH
>>Ahh! Ohh! Oops! my mistake. Didn't know you could do that.
>
>Sorry. I've confuse you with the string name myfilepath&name. It was only a way to say it's a string that includes the path and the file name. I was not a macro substitution. It would look really funny a macro substitution enclosed within quotes.
>Thanks anyway
>Carlos.
Just to clear, went ahead and tried enclosing & within quotes and worked!! That's the reason for exclamations on previous reply. The way I tried it:
(In the command window)
x=" world"
y="hello&x"
? x
And to my surprise, it printed "hello world"! That's why my note stating that I wasn't aware of this until today.
BTW, did you fix your problem?