var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: saving files (VBA)
I would appreciate help with VBA.
I have written a macro that performs a computation every day. I would like to save the computation daily with a different name. For example, I would like to call the result with the current date as the file name. How can I do this?
My question was rather trivial. I apologize. I used VBA today for the first time.
Anyhow, here is one way to do what is required (saving the files on the Desktop):
Dim SendPath, NameFile, SaveAsFile, DateNow
SendPath = "C:\Documents and Settings\Desktop\"
DateNow = Application.Text(Now(), "dd.mm.yyyy;@")
NameFile = "FileName"
SaveAsFile = DateNow
NameFile = NameFile & SaveAsFile
ActiveWorkbook.SaveAs Filename:=SendPath & NameFile, _