Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as pdf with special name
Hi,
I'm trying to save a sheet with a namn from the sheet as a pdf. Do anyone know what I should change in my code below to make it work? Sub Saveas() ' Saveas Makro ' ' Dim Namn As Integer Sheets("Blad2").Select Namn = Range("A1").Value ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "M:\mc\Fevis\Namn.pdf", Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ False Sheets("Blad1").Select End Sub BR Mia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace special character for filename save | Excel Programming | |||
formula to save value of cell w/o copy- paste special-value | Excel Programming | |||
Save Special Filename Multiple Times | Excel Programming | |||
Excel Save As... text with special characters | Excel Discussion (Misc queries) | |||
Urgent! Save Excel WorkBook - a special way | Excel Programming |