Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Button - Macro to print to pdf, then send pdf to email. Tdahlman Excel Discussion (Misc queries) 2 May 1st 23 11:44 AM
Problem sending the command to the program Robert Excel Discussion (Misc queries) 0 December 22nd 09 01:33 AM
How to format the extension less file to print with Dos's Print Command Badshah Excel Discussion (Misc queries) 0 November 28th 06 12:44 PM
How do I print from a file created from sending a print to a file Ted Johnston Excel Discussion (Misc queries) 1 February 23rd 06 03:10 AM
Sending a macro as an executable? Wibs Excel Discussion (Misc queries) 1 December 27th 05 01:41 PM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"