Tony:

Stop by our web and look in the MS Excel developer tools area and you'll
find our XL PDF Wizard add in. It allows you to use any one of 10 different
PDF printer drivers (including Acrobat as well as some other very
inexpensive drivers) to automate creation of PDF documents (including
bookmarks etc.) from XL worksheets or workbooks. It also allows you to
merge in Word documents (with bookmarks,) or external PDF files. You can
also reference the Add In in any workbook and use its properties and methods
to create your own PDF creation jobs. So yes, it can be done.

Hope this helps
--
SA
ACG Soft
http://www.groupacg.com

"tony h" <tony.h.2a7haz_1151655302.9712@excelforum-nospam.com> wrote in
message news:tony.h.2a7haz_1151655302.9712@excelforum-nospam.com...
>
> I have been meaning to play about with this but my initial reaction is
> that it should be possible.
>
> I have a PDF creator setup as a printer option. By making this the
> active Printer or passing this to the activesheet.printout I can get
> the PDF to be created. It is then a fairly simple matter of using code
> to attach the file to an email.
>
> An issue I have here (which you may not have) is that in creating the
> PDF a document profiling form comes up (part of our document management
> system) for whcih the obvious way to handle it is to use sendkeys.
>
> This is (sort of) fine if it is just you using the macro. But otherwise
> you need to wrap this in code to make sure the window is created and
> active before using the send keys.
>
> I am sure there must be a better PDF creator for using in this sort of
> environment.
> I would look for one with an API rather than using it as a printer
> option.
>
> Probably not a huge amount of help.
> regards
>
>
> --
> tony h
> ------------------------------------------------------------------------
> tony h's Profile:
> http://www.excelforum.com/member.php...o&userid=21074
> View this thread: http://www.excelforum.com/showthread...hreadid=556708
>