Hello
I have excel 2007 and I want to create macro to:
1. save active worksheet into the specific folder which is named in the cell R5,
2. name the active worksheet with names in cells R6 and S6,
3. e-mail the active worksheet as pdf to the adresses which are in the cells R7-R20 (may be to name range as "addresses"),
4. open the specific web page,
5. close excel
I found smth. put I can't create an e-mail. Any ideas how to accomplish the macro:
Thank You
Are
Sub MakePDFSaveAndMail()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
ActiveSheet.Range("R5").Value & ActiveSheet.Range("R6").Value & ActiveSheet.Range("S6").Value, Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False
ActiveWorkbook.FollowHyperlink Address:=http://www.yahoo.com
ActiveWorkbook.Close SaveChanges:=False
End Sub
I have excel 2007 and I want to create macro to:
1. save active worksheet into the specific folder which is named in the cell R5,
2. name the active worksheet with names in cells R6 and S6,
3. e-mail the active worksheet as pdf to the adresses which are in the cells R7-R20 (may be to name range as "addresses"),
4. open the specific web page,
5. close excel
I found smth. put I can't create an e-mail. Any ideas how to accomplish the macro:
Thank You
Are
Sub MakePDFSaveAndMail()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
ActiveSheet.Range("R5").Value & ActiveSheet.Range("R6").Value & ActiveSheet.Range("S6").Value, Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False
ActiveWorkbook.FollowHyperlink Address:=http://www.yahoo.com
ActiveWorkbook.Close SaveChanges:=False
End Sub
