I have a Lotus123 spreadsheet that I need to convert to excel. It contains a couple of macros. The one I need help with used file-extract to save a range from the worksheet into a seperate file and then number it consecutively. It's a weekly report so I end up with a folder with file0001.123 thru file0052.123. Is there a simple way to duplicate this in excel?

Thanks, GH