On Oct 24, 4:55*am, GS wrote:
It happens that DaveM formulated :

I'm using the free CutePDF Writer and I would have thought that my
ChDir instruction would have changed the default location in the Save
As Dialog box. *It doesn't!!! *Moreover, the default folder appears to
be the last folder to which any file in my system has been saved.
This is the last step I need to complete the application and I'd
appreciate your help in specifying the appropriate default folder!!
TIA, Dave

Dave,
AFAIK, CutePDF is a 3rd party print driver that does not ship with an
SDK component you can use with programming. IOW, it uses Windows' (API
CommonDialog) SaveAs dialog instead of Excel's and so using ChDir in
VBA has no effect on what/how CutePDF behaves in this regard.

In XL2007+ you can specify the path and folder you 'SaveAs', specifying
filetype as "PDF". You can't do this with CutePDF print driver.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Hi Garry,
Thanks for the response.
That was the answer I was expecting:-( Back to the drawing board
and I'll have to find another way around the problem.
Cheers
Dave