Massey1337
New Member
- Joined
- Mar 8, 2009
- Messages
- 17
Okay my dad has set me a project, apparently it's no more than 6 lines, but I can't get my head around it.
The idea is on an excel worksheet is to enter the name of the file and the data (user does this manually) then clicking the command button will refresh the worksheet, combine the contents of these 2 cells and save the file and e-mail the file to the same e-mail address every time.
My current code is:
I really need help on this, it's sending me round the bend, thanks.
The idea is on an excel worksheet is to enter the name of the file and the data (user does this manually) then clicking the command button will refresh the worksheet, combine the contents of these 2 cells and save the file and e-mail the file to the same e-mail address every time.
My current code is:
Sub Button1_Click()
Dim fname As String
Dim MyDate
MyDate = Date
fname = Worksheets("Sheet1").Cells(3, 2)
fname = fname + MyDate
ActiveWorkbook.SaveAs fname
End Sub
I really need help on this, it's sending me round the bend, thanks.