Sending Print command in a macro

J

janet

I asked this yesterday and didn't get a response so I'm
hoping someone can help me.

I want to set up a macro that will send a print command
that will select the manual feed for the paper source
(under properties of the print command).

I can't seem to find how to set this property. Is it
possible?
 
D

Don Guillett

Haven't tried this but I think you may have to set up printer2 with this
default and then print to that printer.
 
T

Tom Ogilvy

This setting is not directly supported in VBA. Don's suggestion of setting
up a second printer definition with this setting is the easiest approach if
this is just for your machine.

If you are distributing this as an application, you have to use the windows
API to do it, I believe. (or use sendkeys <shudder>)

although this article is about Access and takes advantage of some richer
features in Access, it give a good overview of doing things like this with
the API:

http://www.microsoft.com/accessdev/articles/getzch10.htm?&gssnb=1
 

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

Top