Excel doesn't like those square brackets in filenames. Heck, it doesn't like
those square brackets in sheet names, either.

If you write a formula that refers to a range in another worksheet in a
different workbook, you'll see that excel wraps the filename in those square
brackets.

I do my best to remove them from the filename before doing anything within excel.

And I don't like the # sign in filenames either (if you're fixing names). That
character in the filename will break hyperlinks to that file.





On 04/15/2011 15:25, Tim Childs wrote:
Hi

I have discovered that when I download a CSV file, that always contains a "]",
from the work financial system, the previous Application Event trapping of the
form Wb.Name includes the "]" character no longer traps the the file even though
the actual filename still contains a "]". The Wb.Name now converts the square
bracket "]"to a round bracket ")".

What is really odd is that if I use the Wb.FullName property the "]" is included
in the string Wb.FullName and so I can trap the "]" that way.

My question is why is the Wb.Name property no longer properly reflects the
actual filename (any more).

Any help most welcome.

Tim


--
Dave Peterson