G
Guest
I am trying to save a file with this code it worrks but I don't want to save
it
with the jobdate 10-18-2006. I want to shorten it to 10-18-06
The cell C10 is formatted to mm/dd/yy
I don't do any date calculations
oldjay
jobdate = Range("C10").Value '
jobdate = Month(Jobdate) & "-" & Day(Jobdate) & "-" & Year(Jobdate)
jobname = Range("D6")
jobemployee = Range("G3")
jobnumber = Range("D4")
jobsave = InputBox("Please enter TIME SHEET file name to save",
" Process Technology", "" & "C:\Time Sheets\" + jobnumber + jobemployee +
(Jobdate))
jobsave1 = jobsave + (".xls"
it
with the jobdate 10-18-2006. I want to shorten it to 10-18-06
The cell C10 is formatted to mm/dd/yy
I don't do any date calculations
oldjay
jobdate = Range("C10").Value '
jobdate = Month(Jobdate) & "-" & Day(Jobdate) & "-" & Year(Jobdate)
jobname = Range("D6")
jobemployee = Range("G3")
jobnumber = Range("D4")
jobsave = InputBox("Please enter TIME SHEET file name to save",
" Process Technology", "" & "C:\Time Sheets\" + jobnumber + jobemployee +
(Jobdate))
jobsave1 = jobsave + (".xls"