I have written some VBA code to pull several columns from an Excel
spreadsheet and save these in their own file of *.csv format. However, the
end users would greatly benefit from having the saved date as part of the
filename. I have tried several different methods in my code, but, none are
working. The rest of the code works as intended (I get the new file created
and saved with the new filename).
The relevant code is as follows:
Sheets(Sheets.Count).Name = "Crimson_Info"