Re: Create macro which automaticallly creates PDF of a report

You'll need a PDF printer driver to be installed on your machine. Then
you'll need to use VBA code (not a macro) to change the printer assignment
to the PDF driver, print the report, and then change the printer back to the
default printer. Note that this will work using Application.Printers object
in ACCESS 2002 and 2003.

--

Ken Snell
<MS ACCESS MVP>

"ChuckW" <haji@xxxxxxxxxxx> wrote in message
news:27A2E8D0-4711-4469-9F53-74BBE95BEA66@xxxxxxxxxxxxxxxx
Hi,

I want to create a macro that when run will automatically create a PDF of
an
access report and save it to a certain folder. Can someone help?

Thanks,
--
Chuck W


.

Relevant Pages

  • Re: Run one macro from another and edit filenames for PDF printing
    ... temporary folder that is overly complicated. ... For Each aShape In .Shapes ... the macro seems to only convert the first word doc it finds ... screenshot of how you have your PDF driver setup? ...
    (microsoft.public.word.vba.general)
  • Re: Run one macro from another and edit filenames for PDF printing
    ... PDF would have made things a tad simpler, I prefer to work in 2003. ... ChDir commands as the macro seemed to lose track of where it was working ... Sub BatchPrint2PDF() ... Dim DocList As String ...
    (microsoft.public.word.vba.general)
  • Re: Run one macro from another and edit filenames for PDF printing
    ... I've managed to tweak the PDF driver setup and Acrobat doesn't always stick ... the macro seems to only convert the first word doc it finds in the ... trying to convert with a previous Temp folder ...
    (microsoft.public.word.vba.general)
  • Re: Run one macro from another and edit filenames for PDF printing
    ... Would you say that Word 2007 makes life easier in terms of macro development ... Graham Mayor - Word MVP ... Print to PDF using word doc ... character 'a' with 'q') as PDF filename. ...
    (microsoft.public.word.vba.general)
  • Re: Macros issue with Word 2004 for Mac
    ... you'll get a macro warning every time you open ANY ... are probably trying to open your documents within their email program. ... Saving to PDF is not something that is under Word's control. ... the document is full of heavyweight graphics. ...
    (microsoft.public.mac.office.word)