Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Change registry settings in VBA
Hello. I am pulling my hair out over this one.
I need to be able to take my document and convert it to PDF. Easy
enough but the complication comes in because there are multiple users
of this with very limited knowledge. I need to turn off options and
don't want to tell them, "before you run this, you need to turn off
this check box and that check box." I want the code to run and do
everything for them.
All users have Adobe Acrobat 6 - full -- Note: I do not have the
option to upgrade to 7. For company reasons we can only use version
All users have PDFMaker running in Word 2003.
I see I have two options for conversion. I can have the code run the
PDFMaker code. This works however the big issue is that if the user
has "View Adobe PDF Results" and/or "Prompt for Filename" checked. I
do not want either of these to occur, but like I said I don't want to
rely on the user to have to check it each time they run my code. I
would like the code to see if it is on, then turn it off, then turn it
on again. This would be for both options.
I can't figure out how to code that. I know I could change it via the
registry but I can't figure out how to code that way either.
My other option is to print to the "Adobe PDF" printer. This still has
the problem of needing to check the options.
BTW, I am running all the code from Excel 2003. This is actually a
mail merge type of function and I don't want to have to place code in
both Excel & Word for all the users.
Can anyone help me out with this?