View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kidkarma kidkarma is offline
external usenet poster
 
Posts: 4
Default 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 !