Posting PDF to file

Hello,
I am trying to change the path where the PDF file will go.
This is the formula:

Please Login or Register  to view this content.

At the moment it goes to the personal file but I want it to go to the MIS Invoice file
Any help would be appreciated.
Thank you in advanvce.
Jesse

hi have you tried changing this line to [your new file path]

Please Login or Register  to view this content.

Hello Crooza,
I cannot seem to find how to change to find it's new resting place. "MIS file, sub folder Invoice,".
It still goes to the same file, personal file, sub folder Invoice. If I change "\" with "MIS" ,my new file, I get it in the main personal file whereas before it would go to a sub folder within the personal file.
Tried various changes but get the BUG signal.
Thanks for trying
Jesse

Open the folder where you wish the pdf to go and copy the address from the explorer toolbar

past then to

Please Login or Register  to view this content.

example filepath

Write the full path like “c:\mis\”

Please Login or Register  to view this content.

Dim rng As Range
Dim newpdfname As String
Dim pdfpath As String
Set rng = Application.Selection 'This selects the range of cells to be formatted into PDF
newpdfname = Application.InputBox("Please Enter a name for the new PDF") ' This brings up a box to enter the name of which the PDF file is to be saved
pdfpath = "C:\MIS\& newpdfname"
rng.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=pdfpath, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False

End Sub[/CODE]

the area of the code that I have marked with a is showing up yellow when i run the above suggestions. Neither seem to be working.
Thank you for the suggestions.
Jesse

The path name is in inverted commas. The variable for the file name needs to be outside the inverted commas