Need to open fiile saved w name that included what was in C50. But current C50 will be +1

[ILoveStMartin]

Save 1
xThisWorkbook.SaveAs ThisWorkbook.Path & Application.PathSeparator & Sheet1.Range("C41") & ("-") & Sheet1.Range("C39") & ("- Draw # ") & Sheet1.Range("C50") & ".xlsm"x

Save 2
xThisWorkbook.SaveAs ThisWorkbook.Path & Application.PathSeparator & Sheet1.Range("C41") & ("-") & Sheet1.Range("C39") & ("- Ready to post Draw # ") & Sheet1.Range("C50") & ".xlsm"x

Want to open Save1 while closing Save 2

But, to open using what shows in Save 1, need to change the C50 to C50 minus 1 since what is in C50 will be 1 higher than it was when it was saved.

Have tried many ways but can not find the key, so have to ask - How do I do a C50 minus 1 in the "Save as"?

[Joske920]

Hi,

You do mean the value in C50 to be -1?

Is it certain to be a number all the time?
Sheet1.Range("C50") = Sheet1.Range("C50") - 1

Grtz