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 how I can write this in VBA?

Thanks!!

I use the "PrintToFile" within "PrintOut" Method.

"expression.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile,
Collate, PrToFileName)"

For example:
PrintToFile = "S:\folder\file.pdf"

Fran


"Thomas Cox" wrote:

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 how I can write this in VBA?

Thanks!!