Hia Folks,
What I'm looking to do is get a macro to loop through a single directory and format each of the XL files within that directory ready for printing.
I presume for this I need a macro to open each XL file, apply format, save and close the file and then move onto the next file.
I've searched and not found anything that I can use. Unfortunately I'm not skilled enough in the art of macro writing to utilise bits of code I did find!
I have managed to write / record the code to do the formatting, I just need the the magic bit of code to do the looping!
Cheers...Alkemist...
What I'm looking to do is get a macro to loop through a single directory and format each of the XL files within that directory ready for printing.
I presume for this I need a macro to open each XL file, apply format, save and close the file and then move onto the next file.
I've searched and not found anything that I can use. Unfortunately I'm not skilled enough in the art of macro writing to utilise bits of code I did find!
I have managed to write / record the code to do the formatting, I just need the the magic bit of code to do the looping!
Cheers...Alkemist...