Looping a macro over all files in a folder for a file conversion

Hello there,

I faced with the task of converting thousands of files with the suffix .asc. These are outputted data files with the standard rows and column of numbers. I would like to be able convert these files into .xls files using a macro. However, I really am not too sure how to loop a macro to run on all files within the folder that the .xls macro file currently resides.

So for example, if I have C:\Temp with all the .asc files in it and then the .xls macro is within C:\Temp, I would like be able to run the macros to convert all those .asc files into .xls files. Below is a start of some of what I would like done except for this is on a single file. Can anyone recommend a good way to proceed with this?

Thanks in advance

Please Login or Register  to view this content.

Hi, welcome to the forum.

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to EDIT that post above and put code tags around that code you used. (Like shown in my signature)

Go ahead and fix that post above and I'll post back a version of your posted macro that loops through all the .asc files in the folder and outputs a matching XLS file.

Try this, of course I had nothing to test it on...

Please Login or Register  to view this content.

Something like:

Please Login or Register  to view this content.