Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs filename PDF
Hi,
the code below converts files to pdf after I have already converted the files to post-script file. It all works well and good except what I REALLY want itto do is to create a new folder in C: prob called "temporary" where the pdf's can go and then kill all pdf later. Currently, the pdf's are being saved via a cell where i've typed in the folderlocation called 'saveAsFolder' Current Code psName = staffname & " " & printstring & inc & ".ps" 'Name of PS file pdfName = staffname & " " & printstring & inc & ".pdf" 'Name of PDF myPDF.FileToPDF saveAsFolder & psName, saveAsFolder & pdfName, "" Kill (saveAsFolder & "*.log") Kill (saveAsFolder & "*.ps") Appreciate any help ! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs filename PDF
Real Easy
MkDir "c:\temporary" "kidkarma" wrote: Hi, the code below converts files to pdf after I have already converted the files to post-script file. It all works well and good except what I REALLY want itto do is to create a new folder in C: prob called "temporary" where the pdf's can go and then kill all pdf later. Currently, the pdf's are being saved via a cell where i've typed in the folderlocation called 'saveAsFolder' Current Code psName = staffname & " " & printstring & inc & ".ps" 'Name of PS file pdfName = staffname & " " & printstring & inc & ".pdf" 'Name of PDF myPDF.FileToPDF saveAsFolder & psName, saveAsFolder & pdfName, "" Kill (saveAsFolder & "*.log") Kill (saveAsFolder & "*.ps") Appreciate any help ! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs filename PDF
Look into the MkDir statement.
NickHK "kidkarma" wrote in message oups.com... Hi, the code below converts files to pdf after I have already converted the files to post-script file. It all works well and good except what I REALLY want itto do is to create a new folder in C: prob called "temporary" where the pdf's can go and then kill all pdf later. Currently, the pdf's are being saved via a cell where i've typed in the folderlocation called 'saveAsFolder' Current Code psName = staffname & " " & printstring & inc & ".ps" 'Name of PS file pdfName = staffname & " " & printstring & inc & ".pdf" 'Name of PDF myPDF.FileToPDF saveAsFolder & psName, saveAsFolder & pdfName, "" Kill (saveAsFolder & "*.log") Kill (saveAsFolder & "*.ps") Appreciate any help ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SaveAs Cell.value=filename | Excel Programming | |||
SaveAs with a pre-defined filename | Excel Programming | |||
SaveAs using two cells for filename | Excel Discussion (Misc queries) | |||
FileName SaveAs | Excel Programming | |||
SaveAs Filename Help | Excel Programming |