VBA to print to PDF

[klarowe]

I am not sure if this will be possible or not, but if anyone can help I would greatly appreciate it.
I want to add a button to this workbook I'm working on that when pressed will activate ToggleButton1, bring up a confirmation message box "Save-As (Cell A1 Value) teardown.pdf"(Yes/No)(No to cancel), then print to PDF into S:\SERVICE\Shop Teardown Reports\PDF Teardowns with a name of "(Cell A1 value) teardown"

Now here is where it gets difficult. Right now there are different ways that we can print to PDF depending on which computer is used. Some of them have "Adobe PDF" as the "printer" and others have "Primo PDF" as the printer because some of us have Adobe Acrobat, and others just have Adobe Reader.

Is this possible???
Thanks again for all the help!!!

 

[GQue]

Try looping thru the list of printers available until the

Right(PRINTERNAME,4) = " PDF"

That should solve that issue...

 

[klarowe]

I would love to do that, but up until I started working on this project (about 2 weeks ago) I had never even heard of a macro... so my over-all code writing is almost non-existant... lol. I really more need the entire code or at least a general idea that I can mess around with until I find something that works.. lol.
Thanks

 

[GQue]

As much as I would love to write the code for you, I unfortunately do not have the spare time to do it.

You can learn the basics of VBA in less than a week and then use snippets off the web to fill in the blanks.

Good luck and sorry again I couldn't help further.

 

[klarowe]

Thats no problem. I've been taking snippets and working off them and I'm currently working on it, I just figured if someone has some spare time and can get me the general idea it would save a little time. No big deal though.
Thanks for the help!