I am trying to figure out how to automate a word doc to pdf without having the user to intervene.
At the moment i have an app that open word tempates, populates them with data from an access db using vba.
They are then automatically printed onto the correct prints (sometimes some editing is required) , then they are automatically saved to a directory based on the client (folder is created if not existing already).
I have tried setting the default printer to Adobe PDF, but this ends up prompting the user each time (there are around 10 different word docs).
The first question is whether there is any way of automatically saving the pfd via vba. If not, is there any way to default the save directory (or windows or adobe) so that the user does not have do navigate their way to the correct directory.
Should this be posted in the vba forum, I got told off by someone for posting twice, so I will wait before posting there too!!
Many thanks in advance
Andrerw
At the moment i have an app that open word tempates, populates them with data from an access db using vba.
They are then automatically printed onto the correct prints (sometimes some editing is required) , then they are automatically saved to a directory based on the client (folder is created if not existing already).
I have tried setting the default printer to Adobe PDF, but this ends up prompting the user each time (there are around 10 different word docs).
The first question is whether there is any way of automatically saving the pfd via vba. If not, is there any way to default the save directory (or windows or adobe) so that the user does not have do navigate their way to the correct directory.
Should this be posted in the vba forum, I got told off by someone for posting twice, so I will wait before posting there too!!
Many thanks in advance
Andrerw
