Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default folder when saving a "Cute" PDF file
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default folder when saving a "Cute" PDF file
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 at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default folder when saving a "Cute" PDF file
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I change Excel 2003 default "save to" folder? | Setting up and Configuration of Excel | |||
Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab? | Excel Programming | |||
Changing default "import" folder | Excel Discussion (Misc queries) | |||
creating an XLS file from " files" data in a Folder | Excel Discussion (Misc queries) | |||
Backup to specific folder if workbook names begins with "NSR" or "MAC" | Excel Programming |