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

Thanks!!