You are reading a single comment by @NotThamesWater and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@NotThamesWater
[code]dim myFileName as string
....
myFileName = whatevercell.value & "some other words" & Format(Now, "mm") & ".xlsx"
...
ActiveWorkbook.SaveAs Filename:=myFileName
[/code]
or something - I forget the save file bit
[Edit] That's it