VBA Code to Provide Dir and File When Converting to PDF

D

DevDaniel

Not sure if this can be done with VBA ...

I have:
A macro that launches a pdf maker. The pdf maker opens the file browser and
prompts for a directory and file. The user must manually browse to the
directory and enter a file name.

I want:
VBA code to automatically supply the directory and file, so there is no user
intervention.

Any suggestions?

Code snippet:

acrobatpdfmaker.ConvertToPDFA
ActiveWorkbook.Close Filename:=strDirFile
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top