View Single Post
  #1   Report Post  
Bill
 
Posts: n/a
Default Macro - Feeding path and file name to PDF maker

Hi,

I am using a macro to create a report and the last step is to print a
particular worksheet using a PDF maker. I have figured out how to specify
the printer as being the PDF maker, but I also want to be able to
automatically enter the file name and path, which I will build within the
macro depending upon some user inputs. I've built the text strings as I
need, I just need to be able to "feed" them to the PDF maker rather than
have the dialog box come up and ask the user for that information.

Any help?

Bill