Hi again,

I have 6 sheets in my workbook. I want to save the sheet called "RFQ"
as a PDF, copy it to a new folder called "RFQ to Admin" and then name
the file as whatever company I have listed on the Order worksheet in
cell B4. Is this possible, or am I out of control? <g

Do you want to create the folder ?

Where ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Veronica Johnson" wrote in message ...
Hi again,

I have 6 sheets in my workbook. I want to save the sheet called "RFQ"
as a PDF, copy it to a new folder called "RFQ to Admin" and then name
the file as whatever company I have listed on the Order worksheet in
cell B4. Is this possible, or am I out of control? <g

On Jan 25, 4:08*pm, "Ron de Bruin" wrote:
Do you want to create the folder ?

Where ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Veronica Johnson" wrote in ...
Hi again,

I have 6 sheets in my workbook. *I want to save the sheet called "RFQ"
as a PDF, copy it to a new folder called "RFQ to Admin" and then name
the file as whatever company I have listed on the Order worksheet in
cell B4. *Is this possible, or am I out of control? *<g- Hide quoted text -

- Show quoted text -

Yes, I have already created the folder in My DocumentsCust Maint on
the C: drive.

Test this one Veronica

Check the path and sheet name here before you run the macro

FilenameStr = "C:\My Documents\Cust Maint\RFQ to Admin\" & _
Sheets("Order").Range("B4") & ".pdf"


Sub RDB_PDF_ActiveSheet_Test()
Dim FilenameStr As String

If Dir(Environ("commonprogramfiles") & "\Microsoft Shared\OFFICE" _
& Format(Val(Application.Version), "00") & "\EXP_PDF.DLL") < "" Then

FilenameStr = "C:\My Documents\Cust Maint\RFQ to Admin\" & _
Sheets("Order").Range("B4") & ".pdf"

Sheets("RFQ").ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=FilenameStr, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False
MsgBox "You can find the PDF file here : " & FilenameStr

Else
MsgBox "PDF add-in Not Installed"
End If
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Veronica Johnson" wrote in message ...
On Jan 25, 4:08 pm, "Ron de Bruin" wrote:
Do you want to create the folder ?

Where ?

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Veronica Johnson" wrote in ...
Hi again,

I have 6 sheets in my workbook. I want to save the sheet called "RFQ"
as a PDF, copy it to a new folder called "RFQ to Admin" and then name
the file as whatever company I have listed on the Order worksheet in
cell B4. Is this possible, or am I out of control? <g- Hide quoted text -

- Show quoted text -

Yes, I have already created the folder in My DocumentsCust Maint on
the C: drive.