New Forum | Previous | Next | (P-PDF) Developers
Topic: Passing file name & location to Writer w/ VB code from PowerPoint
Conf: (P-PDF) Developers, Msg: 73489
Date: 10/3/2002 06:18 AM
I'm hoping that someone has figured out how to do the subject and over write the existing file
and can share the VB code with me. I know how to do it from Excel with:
If Dir$(LocationA & cell & ".pdf") <> "" Then
'erase previously created file names
Kill (LocationA & cell & ".pdf")
'print the sheets as one PDF
Sheets(Array("Rep Score Card", "SupplierActivityand6MoAR", "SER data", "Audit data",_
Application.SendKeys (LocationA & cell & ".pdf~")
ActiveWindow.SelectedSheets.PrintOut ActivePrinter:="Acrobat PDFWriter"
The "~" over rides, or what ever the terminology is, the window that normally pops up
while doing it manually...
TIA for what ever help you can provide.