I have been searching days for a solution to this problem. I am using Excel
2002 with Adobe 6.0 to create reports. I know all the different routes to
take: print to file as .ps and then convert, using the distiller, but I am
using the

Application.ActivePrinter = "Adobe PDF on Ne00:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne00:", Collate:=True

Which then brings up a Save As prompt. I am trying to send the filename to
the box via vba. I have tried the SendKeys function which I have used in
other code for basically the same purpose but it doesn't work.

Does anyone have a solution for this, if so it would be greatly appreciated.

Thanks



--
Keep it real up in the field, aaaaright