VBS, Save Copy of file name as with todays date

Asked Apr 13 '22 at 15:24

Active Apr 13 '22 at 15:24

Viewed 249 times

I am running a VBS and trying to save a copy of the file with the newest date.

currently I use wb.Save which saves the current copy nicely.

Anyone know why these two attempts dont work? The dialog box closes immediately when trying these two different attempts.

   wb.SaveCopyAs Filename:="O:\Desktop\Export " & Format(Now, "yyyy-mm-dd") & ".xlsm"
    wb.Save Filename:="O:\Desktop\Export " & Format(Now, "yyyy-mm-dd") & ".xlsm"

Thanks.

asked Apr 13 '22 at 15:24

Jonnyboi

What dialog box? – Tim Williams Apr 13 '22 at 16:24
sorry the black cmd prompt box. – Jonnyboi Apr 13 '22 at 16:50
A bit more detail might be useful here around exactly how you launch your vbscript. Maybe that folder doesn't exist on your Desktop (are you missing a "\" after Export) ? – Tim Williams Apr 13 '22 at 17:11
Maybe this - https://stackoverflow.com/questions/42194300/does-vbscript-allow-named-arguments-in-function-calls Note sure you can use named arguments in VBScript. – Tim Williams Apr 13 '22 at 17:13

VBS, Save Copy of file name as with todays date

0 Answers0