Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting formulas to code | New Users to Excel | |||
Converting Excel file to text delimited file | Excel Discussion (Misc queries) | |||
Needs help converting some pseudo code into VB code | Excel Programming | |||
Converting excel file to tab delimited (txt) file | Excel Discussion (Misc queries) | |||
Import VBA Code in Excel-File ? (Export VBA Code to file) | Excel Programming |