rhombus4
Well-known Member
- Joined
- May 26, 2010
- Messages
- 586
- Office Version
- 365
- 2016
- Platform
- Windows
If I have a file called book5 and in sheet5 A5 it has the value id 222, how do I save the file using both values.
Result should be book5 id 222.xlsm
ActiveWorkbook.SaveAs (sheets("sheet5").Range("A5").Value & ".xslm")
Result should be book5 id 222.xlsm
ActiveWorkbook.SaveAs (sheets("sheet5").Range("A5").Value & ".xslm")