Hi
The simple macro below works fine but asks to overwrite, which in this instance is an unnecessary delay.
I will use this macro 100s if not 1000s of times so would really like to solve this issue.
Any help really appreciated
The simple macro below works fine but asks to overwrite, which in this instance is an unnecessary delay.
I will use this macro 100s if not 1000s of times so would really like to solve this issue.
Any help really appreciated
Code:
Sub savepreset()
'
' savepreset Macro
'
'
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\paul\Documents\Excel Scripts\FX\default.dff", _
FileFormat:=xlTextMSDOS, CreateBackup:=False
End Sub
Last edited: