Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Print command in a macro
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Print command in a macro
Haven't tried this but I think you may have to set up printer2 with this
default and then print to that printer. "janet" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending Print command in a macro
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/a...0.htm?&gssnb=1 -- Regards, Tom Ogilvy "janet" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button - Macro to print to pdf, then send pdf to email. | Excel Discussion (Misc queries) | |||
Problem sending the command to the program | Excel Discussion (Misc queries) | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
How do I print from a file created from sending a print to a file | Excel Discussion (Misc queries) | |||
Sending a macro as an executable? | Excel Discussion (Misc queries) |