Save to specific location

[PDBartlett]

Hello

This bit of code saves the active sheet (PDF) to the same location as the workbook. How can I add to it to make it save to a folder called "Quotes" within the location of the workbook?

Thanks

Please Login or Register  to view this content.

[TMS]

Have you tried:

Please Login or Register  to view this content.

The sub-folder will need to exist.


Regards, TMS

[PDBartlett]

Brilliant, thank you!

[TMS]

You're welcome. Thanks for the rep.




If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[PDBartlett]

TMS, currently it's PDF'ing all the pages on the active sheet. Any idea on how to make it PDF them all except page 1? Or something like From page 2 To 10

[PDBartlett]

Solved! I just changed the print area to ignore the first page - so simple!