W
WOMBAT
I want to save an Excel workbook using a name calculated
by VBA, but I want to give the user the opportunity to
alter the name. I thought I could do this by using a
xlDialogSaveAs, but then how do I cause VBA to write the
suggested name into the Filename box so that the user can
check & change it if necessary it before hiiting SAVE?
by VBA, but I want to give the user the opportunity to
alter the name. I thought I could do this by using a
xlDialogSaveAs, but then how do I cause VBA to write the
suggested name into the Filename box so that the user can
check & change it if necessary it before hiiting SAVE?