Is it possible to print a pdf file through vba? If so, how? I would prefer
to do this rather than import into my spreadsheet to keep the size down. I
use Excel 2000.

Robert

Robert,
If you have Adobe Acrobat or some 3rd party pdf drivers, then:
Application.ActivePrinter = "Adobe PDF on Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne01:", Collate:=True

(Note: Use record macro to see what default pdf driver is chosen).

"Robert Dieckmann" wrote:

Is it possible to print a pdf file through vba? If so, how? I would prefer
to do this rather than import into my spreadsheet to keep the size down. I
use Excel 2000.

Robert

Perhaps my question was unclear. I already have the pdf file which was
generated from AutoCAD. I want to send that file to a standard printer
along with some related information from the spreadsheet. I am not
looking to create a pdf file from the spreadsheet, I already have that
covered. What I want to avoid is having to import the AutoCAD drawing
into my spreadsheet in order to print it. I am distributing my
spreadsheet to others within the company who do not have access to
AutoCAD & I am trying to simplify the process for them so that they can
print what they need with the click of a button. Sorry for the
miscommunication.



*** Sent via Developersdex http://www.developersdex.com ***

I had luck using the Shell command:


Sub Tester2a()
Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe" & _
" c:\toc1\amcr37-4.pdf", 1
' the following prints the document
Application.SendKeys "^p~", False
End Sub


or if you have .pdf associated with acrobat reader:


Private Sub CommandButton1_Click()
Shell "Start.exe ""D:\My Documents\sm569_Jan2001\tute6.pdf"""
Application.SendKeys "^p~", False
End Sub


--
Regards,
Tom Ogilvy


"Robert Dieckmann" wrote in message
...
Perhaps my question was unclear. I already have the pdf file which was
generated from AutoCAD. I want to send that file to a standard printer
along with some related information from the spreadsheet. I am not
looking to create a pdf file from the spreadsheet, I already have that
covered. What I want to avoid is having to import the AutoCAD drawing
into my spreadsheet in order to print it. I am distributing my
spreadsheet to others within the company who do not have access to
AutoCAD & I am trying to simplify the process for them so that they can
print what they need with the click of a button. Sorry for the
miscommunication.



*** Sent via Developersdex http://www.developersdex.com ***