Can anyone recommend a better Macro to be able to do the following:
1. Choose where you can save the exported file
2. MAXIMUM quality of export
Here is what I'm currently using:
Thanks as always!Please Login or Register to view this content.
Can anyone recommend a better Macro to be able to do the following:
1. Choose where you can save the exported file
2. MAXIMUM quality of export
Here is what I'm currently using:
Thanks as always!Please Login or Register to view this content.
Let's start with this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
The codes not working unfortunately, I do appreciate your time though!
And what exactly doesn't work ?
You asked for a Folderpicker and that's what you got.
Apologies if I'm being a fool here, just my .jpg export code automatically pops up with a folder picker without me typing it into the code:
Do you have any other code still running while trying to execute ExportPDF ?
No I closed the document and re-opened it to be sure.
Here is the code I use for .jp with folder picker:
I can't write code I can just take bits and pieces from people and sometimes get things working but then other times like now I get a bit stuck.Please Login or Register to view this content.
Thanks
I'm sorry but I don't see the connection between this code and the code I posted you.
These are completely seperate things.
I'm just giving you an example of something I have that works for .jpg and tried to then get the same outcome with .pdf
Something like this then ?
Please Login or Register to view this content.
Last edited by bakerman2; 06-16-2018 at 06:33 PM.
Unfortunately another error message, apologies.
There's a b too much in End Sub. My bad.
You are probably using Option Explicit so you have to put this
as first line of the codePlease Login or Register to view this content.
That has now stopped me from having to add a file location into the code however, it automatically saves to my desktop and then opens the 'SaveAs' option but there is no PDF option and it only lets me select 'All Files (*.*)'
My problem is that this document is for multiple people to use so they need to get the option of where to save the PDF file once they click the macro button.
Any further suggestions welcome and appreciated
This code let's you select a folder and the oppertunity to fill in a filename. you don't need to add or select an extension because it will be added automatically upon saving.Please Login or Register to view this content.
You can even refer to a certain cell to fill in a standard filename.
After clicking OK the file will be saved in the location with the filename which you have filled in.
How much easier can it get.
That's working perfectly... much appreciated Bakerman2, top work!
Last edited by davo3286; 06-17-2018 at 06:50 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks