msquared99
Member
I have a macro that errors out on the line of code that says ActiveWorkbook.
The exact same code runs well in one place but not the other.
Any idea why?
The exact same code runs well in one place but not the other.
Any idea why?
Code:
sFileName = "MN Packout Log " & Format(Now, "mm-dd-yy") & ".xlsm"
sBasePath = "C:\General Use\UPS Daily Tracking\Logs\"
ActiveWorkbook.SaveAs sBasePath & sFileName