M
Michelle
I am trying to save another (differently named) version of my file whenever
I save.
It works fine if I use the normal save, but if the save is triggered from
the Before_Close event, it just skips over the following line...
ThisWorkbook.SaveAs Filename:=CurrPath & "\" & CurrName
in debug, it finds the line (it goes yellow), it doesn't generate any
errors, but it steps through the line without doing any saving
The CurrPath and CurrName variables do contain valid text
Why is it not saving?
thanks
M
I save.
It works fine if I use the normal save, but if the save is triggered from
the Before_Close event, it just skips over the following line...
ThisWorkbook.SaveAs Filename:=CurrPath & "\" & CurrName
in debug, it finds the line (it goes yellow), it doesn't generate any
errors, but it steps through the line without doing any saving
The CurrPath and CurrName variables do contain valid text
Why is it not saving?
thanks
M