Save as PDF in a difined directory

[deanblew]

Hi all,

I have got a macro to create a PDF but it always saves as the same name i.e. C:\pdf\RFI pdf.

I have to rename the file as something different each time, the ref is contained in cell C2 of the active worksheet.

Is there a way I can save the pdf and it saves as a named file which refers to a ref in cell C2 of the worksheet?

I have an issue with where to place the code for the following! I have been told to insert this code but cant figure out where!

& Sheets(Sheet Name Here).Range("C2").Value


can you highlight where i need to add the code?
the sheet mane is RFI ENQ.

Sub PDF()
'
' PDF Macro
'

'
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"H:\Documents\1_CAPABILITY INSERTIONS\30_RFI's\RFI.pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub

thanks

D

[anilpatni1234]

Please Login or Register  to view this content.

I have this code which saves as excel file with Password.
If you wish to remove Password then delete

Please Login or Register  to view this content.

File format you can change to "Pdf"

[deanblew]

hi, handy code but not what im after.

thanks

[davsth]

You should put your code in code tags

Please Login or Register  to view this content.

or change nametosave=Range("C2").value
to nametosave=Range("C2").value & ".pdf"

[deanblew]

I’m really new at using code, don’t really understand much as yet so I record a macro but it’s not giving me everything I need, I’ll get there slowly. I don’t know what or where to place code tags. I’ll try this when I get back to my pc.

Thanks for your help