ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SaveAs filename PDF (https://www.excelbanter.com/excel-programming/384799-saveas-filename-pdf.html)

kidkarma

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 !


joel

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 !



NickHK

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 !





All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com