creating a loop for saving a file and increase a variable by one after every saving

Hi,
I have this long but easy to understand vba code. How can I increase the z value by one after every round of saving the file? Right now I have to manually type in the numbers where it says z=4. I want the z value to increase up to 300 starting from 4. Also I want the last line (ActiveWorkbook.SaveAs Filename:=pathname & SaveFile & “M34.xlsb”) to be changed corresponding to the z value. So if z=4 then the file should be saved as M34. If z=5 then the file should be saved as M35 and so on. So M should be always saved as M30+z. thanks a lot for your help guys. I really appreciate it.

Please Login or Register  to view this content.

One way. On a separate sheet. In this sample I named it "z Values". In Column A you list the numbers down from 4 to 300.

Please Login or Register  to view this content.

In your sub

z = Sheets("z Values").Range("A1").Value

Originally Posted by Norie

Do you meant that the next time you run this code you want z to be 5, then next time 6, next time 7 etc?

yes that is exactly what i want.

somehow the loop doesnt work. do u know why

norie. it does one loop and then stops.

hi,
each time i run the code i get 34.xlsb. the static variable does not increase by one. As for the code in post #4 i get a syntax error for the line
lr = Cells(Rows.Count, 1).End(xlUp).Row - 1

i tried it many times. whenever i run the code #4 i get only one loop. it does not go from 4 to 300. It only does one loop and saves the file. the static variable in post #6 does also not work. whenver i run the #6 the variable does not increase by one. am i doing something wrong?