Converting Excel Worksheet to PDF using VBA

[Thomas Cox]

I have a small problem when trying to to convert Excel to *.PDF using VBA.
All I need to do is to open adobe and the save as dialog box to be straight
on to a shared directory rather than displaying the My Docs folder for the
save point.

Any ideas?

Thanks!!

 

[NickHK]

Thomas,
Go to the properties of the Adobe printers in Control panel>Printers.

Then Ports>Add Port. Select the required folder and then make sure it is
checked as the active port for Adobe PDF.

NickHK

 

[Thomas Cox]

Thanks that has worked brilliant!!
Tom

Thomas,
Go to the properties of the Adobe printers in Control panel>Printers.

Then Ports>Add Port. Select the required folder and then make sure it is
checked as the active port for Adobe PDF.

NickHK