User Profile

Jrams · Apr 22 '13, 08:39 PM

One workaround, but not a full solution, I have found:
var = dir() produces an ASCII result &, hence, the subsequent error

But originally acquiring the filename via FileSystemObjec t produces an ANSI result:

Code:

    Set fso = CreateObject("Scripting.FileSystemObject")
    Set ff = fso.GetFolder(FolderName)
    Set f = ff.Files
    For Each var in f

Hard to believe that a dir() iteration...

Jrams · Apr 22 '13, 02:28 PM

OK... the initial application will be for/in VBA.

Jrams · Apr 22 '13, 03:20 AM

Thanks, Rabbit... either will work, perhaps VB6 will have broader application?

Jrams · Apr 20 '13, 03:21 PM

vijay6, thanks for your response... but it makes me realize that I somehow got my query posted t the wrong forum. I need a solution in VB6 / VBA. Sorry to not be able to use your prompt help.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Foreign Characters in Filename - How to manage