VB Script help

[ameetd]

Hi Guys,
i need help in reading the filenames from the folder into a excel file. Probably a macro will also do.

[MMcCarthy]

Hi Guys,
i need help in reading the filenames from the folder into a excel file. Probably a macro will also do.

I am moving this question to the Visual Basic forum where it is more likely to be answered.

Mary

[Killer42]

Hi Guys,
i need help in reading the filenames from the folder into a excel file. Probably a macro will also do.

This won't be too hard to do in a macro. Probably the simplest would be to use the Dir( ) function. I'm short of time now, but should be able to get to this at lunch time tomorrow (it's Sunday evening here now).

If you want to play with it, just create a macro then edit it. Look for the first file by using something like SomeVariable = Dir("*.*"). Then get each subsequent one by using SomeVariable = Dir( ). When it returns an empty string, you've run out of files.