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
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