LinkBack URL
About LinkBacks
Hi EMoe!
Use the Format function to coerce values to the format you need like this (replace my format to what you want it to look like):
ActiveWorkbook.SaveAs Format(Range("B1"), "yyyy_mm_dd")
Hope this helps,
theDude
Hi EMoe!
Use the Format function to coerce values to the format you need like this (replace my format to what you want it to look like):
ActiveWorkbook.SaveAs Format(Range("B1"), "yyyy_mm_dd")
Hope this helps,
theDude
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks