Converting Excel Worksheet to PDF using VBA
 

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

Converting Excel Worksheet to PDF using VBA
 

Thomas,
Go to the properties of the Adobe printers in Control panelPrinters.

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

NickHK

"Thomas Cox" wrote in message
...
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!!

Converting Excel Worksheet to PDF using VBA
 

Thanks that has worked brilliant!!
Tom

"NickHK" wrote in message
...
Thomas,
Go to the properties of the Adobe printers in Control panelPrinters.

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

NickHK

"Thomas Cox" wrote in message
...
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!!