View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DevDaniel DevDaniel is offline
external usenet poster
 
Posts: 14
Default VBA Code to Provide Dir and File When Converting to PDF

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