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

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" <(E-Mail Removed)> wrote in message
news:42fb1bfc$0$17459$(E-Mail Removed)...
> 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!!
>
>

Thanks that has worked brilliant!!
Tom

"NickHK" <(E-Mail Removed)> wrote in message
news:OZ4%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:42fb1bfc$0$17459$(E-Mail Removed)...
> > 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!!
> >
> >
>
>