Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The below works but I have two questions.
Question 1. How do I change this to access the sheets name? Question 2. Can this code be condensed and still provide the same result? Using Excel 2007.... Sub Updateforms() Sheets(Array("PageFirst", "AAlt", "PageLast")).Select Sheets("PageFirst").Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "S:\PUBLIC\FundPerf\Performance flier\AA0508.pdf", Quality:=xlQualityStandard _ , IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False End Sub -- Wag more, bark less |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a New Macro | Excel Discussion (Misc queries) | |||
Creating Macro | Excel Discussion (Misc queries) | |||
Macro Creating | New Users to Excel | |||
Creating a macro | New Users to Excel | |||
Need Help Creating A Macro | Excel Worksheet Functions |