toasterlad
New Member
- Joined
- May 27, 2010
- Messages
- 10
Need another set of eyes on this. Trying to save a workbook with dates in the title that are specified by using an input box. Workbook saves when I leave out the dates, but I can't see any reason why using the dates would cause the method to fail:
AnsRS = InputBox("Report Start Date (mm/dd/yy)", , Format(Date, "mm/dd/yy"))
AnsRe = InputBox("Report End Date (mm/dd/yy)", , Format(Date, "mm/dd/yy"))
ActiveWorkbook.SaveAs ("N:\Accpay\Approval Lists\Approval Listing Source Data\Scratchpad\Weekly Updates " & AnsRS & "-" & AnsRe & ".xlsx")
AnsRS = InputBox("Report Start Date (mm/dd/yy)", , Format(Date, "mm/dd/yy"))
AnsRe = InputBox("Report End Date (mm/dd/yy)", , Format(Date, "mm/dd/yy"))
ActiveWorkbook.SaveAs ("N:\Accpay\Approval Lists\Approval Listing Source Data\Scratchpad\Weekly Updates " & AnsRS & "-" & AnsRe & ".xlsx")