Visual Basic in Excel

aj9648

Hi

This may not be the most appropriate place to post this - but is anyone any good with VB code and helping me out as I am stuck??

Sorry if this is inappropriate!!!

Thanks

AJ

isofa

Yes it's the right place... What are you stuck with?

aj9648

Will PM you isofa

Thanks

isofa

What you could do is get a list of file names in a directory, save these into a spreadsheet, and the have VBA code step through these, to run, convert and save as CSV by your code.

You can write a subroutine to access directories, but you'll need a bit of detailed VBA knowledge to step through it all. So you could just save a directory listing in windows, paste it into a spreadsheet, and then work on that instead as the list.
you'd need to set a variable eg:

f=Dir(Directory,7)
and then loop through this saving the file names in a sheet e.g.
cells(loopcounter,1) = f
etc

Does that make sense?

I'm not in front of a machine with XL/VBA on at the moment, so I can't be more specific.

There'll be good code snippets at: www.mrexcel.com