How can I create text files with special characters in their filenames?

Value retrieved from the cell is already in Unicode.

You are on the right track with the FileSystemObject. As Morbo mentioned you can late bind this so no reference is set. The FSO has a CreateTextFile function which can be set in unicode so the characters will appear as '?' in VBA but will write correctly to the filename.

Note the second parameter of the CreateTextFile function specifies a unicode string for the filename. The following will do the trick for you.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions