Controlling printing with VBA

[paulricot]

I have been reading a number of websites dedicated to the "Sendkeys" method of controlling the printer from within Excel 2010. However, I can only get as far as the "Print" screen in the "File" menu using the following:

Application.SendKeys "%fp%ri", True or
Application.SendKeys "%fpr", True

When I run the above, it usually gets stuck on the main Print screen and (helpfully) shows superscript key helps to tell you which keys run what. But when you add these keys to the string, nothing happens. Grrrr!

Any ideas anyone?

 

[Norie]

What exactly are you trying to control?

By the way, SendKeys is kind of <S>totally</S> unreliable perhaps there's another method/approach you could use.