help please <d :D

A

aking1987

Forget the above issue...

NEW ISSUE:

We would like to write the end spreadsheet to PDF (Acrobat Distller)
If the user does not have the program i would like an error msg to b
displayed (MSGBOX).

Is there any way to detect the users list of printers, and if Distille
is not present then display the error?

thank
 
M

Myrna Larson

Access has an Application.Printers collection. Excel doesn't. Word doesn't. If
your users have Access, you could get at it that way. Otherwise, I supposed
you'll have to use Windows API calls and/or access the Registry to get the
list.

There may be another problem: there programs other than Adobe Acrobat that can
create PDF files. Some are free, some are under $50. Do you want to preclude
use of those programs?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If column A = B then pick up value in D. 3
Compare A&B columns with C&D columns 4
Conditional Highlight 16
help please <d :D 0
Challenging Formula Issue 1
Need help modifying code 0
Function help needed please. 3
Loop or Find code ?? need help !! 4

Top