Ernest Ansah
New Member
- Joined
- Oct 12, 2022
- Messages
- 12
- Office Version
- 2019
- Platform
- Windows
Hello .. please kindly help me with a macro that can save a sheet as pdf using a cell range and the date below are the codes
saveLocation = "C:\Users\Public\Documents" \ "BS-2TERM 1 " & Range("b5") & Format(DateTime.Now, "-yyyy-MM-dd hh-mm-ss") & ".pdf"
saveLocation = "C:\Users\Public\Documents" \ "BS-2TERM 1 " & Range("b5") & Format(DateTime.Now, "-yyyy-MM-dd hh-mm-ss") & ".pdf"