Vba to run some codes then save file to different filenames

[bezbid]

Hi all, thanks in advance

I have a code to run on a file, then I need to save the file as "x_Sample_01.xlsb", then will run the code to this file again and save to another filename "x_Sample_02.xlsb",

the filenames will be saved with the last 2 chr from 01~.., how can this be done

[bezbid]

I have found this code, it do the tricks, but the first 9 file is saved as x_Sample_1.xlsb instead of x_Sample_01.xlsb, how to alter the code?

Please Login or Register  to view this content.

[YasserKhalil]

Try to edit this part

Please Login or Register  to view this content.