macrosmicrosoft excel
When recording a macro in Excel (2007) the recorder will often wrap the lines of code if they get to long by using a "_" character. This is all well and good except that there is apparently a hard limit of how many times a line can be wrapped in the VBA IDE, and if the recorder exceeds that limit it stops recording.
Is there any way to prevent the macro recorder from auto-wrapping the recorded code so that long lines can be recorded without blowing up the IDE?
To accomplish the title of your post you are looking for Now with some date manipulation.
Sub STUFF()
Dim msg As Outlook.MailItem
Set msg = Application.CreateItem(olMailItem)
msg.To = "email@email.ca"
msg.CC = "BumblebeeJoe@email.ca"
msg.Subject = "STUFF STUFF STUFF" & Now
msg.Body = "PERSON, STUFF STUFF STUFF" & Now
msg.Display
msg.Attachments.Add ("e:\temp\" & Format(Now, "dd.mm.2014") & ".xlsx")
Set msg = Nothing
End Sub
Now would just return the date which in our case is just appended to the strings for Subject and Body. If you are looking to format the date you would use something like Format(Now, "dd.mm.2014") that you see in the Attachment.Add example. More date formatting examples
As for the attachment that is fairly simple. I have not done any data validation for paths which you should do but I ended up with the following in my test. This also entirely depends on your file naming conventions.
Then all you would need to do is something like assign a quick access toolbar button to your macro.
Best Answer
I don't think this is configurable in the editor. You can get a few more charactors before going over the limit by changing your tab width options however.