ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PDF 7.0 & Macro (https://www.excelbanter.com/excel-programming/355490-pdf-7-0-macro.html)

Scooby

PDF 7.0 & Macro
 
I need to be able to create a macro that will record what printer settings i
set when i go to print... I have tried and it will not record it.

Does anyone know how to do this?

I know I can set my defaults in control panel but it does not seem to stay
and I do not know why either.

Help please!

davesexcel[_53_]

PDF 7.0 & Macro
 

before you record your macro, be sure the printer you want to select, is
not already selected, then when you record the macro, you will then
select the one you want and there fore, your selection will get
recorded.


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326


Scooby

PDF 7.0 & Macro
 
Hey Dave.. thanks for the reply.. i got it to do that... its the part where I
need it to record the settings I set for the printer that it does not do.

Any ideas?

"davesexcel" wrote:


before you record your macro, be sure the printer you want to select, is
not already selected, then when you record the macro, you will then
select the one you want and there fore, your selection will get
recorded.


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326



Scooby

PDF 7.0 & Macro
 
let me be a bit more specific... its recording the settings i change for the
pdf writer printer.... doesnt seem to record it

"Scooby" wrote:

Hey Dave.. thanks for the reply.. i got it to do that... its the part where I
need it to record the settings I set for the printer that it does not do.

Any ideas?

"davesexcel" wrote:


before you record your macro, be sure the printer you want to select, is
not already selected, then when you record the macro, you will then
select the one you want and there fore, your selection will get
recorded.


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326



davesexcel[_56_]

PDF 7.0 & Macro
 

I am curious, do the settings record when you select a different
printer???


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326


Scooby

PDF 7.0 & Macro
 
No it does not seem to. I attempted to simply change from portrait to
landscape on my regular laser printer and still did not record it.

We were able to keep the settings in Control Panel so that the fonts would
not send to pdf but still need the macro to make it print to pdf correctly.

"davesexcel" wrote:


I am curious, do the settings record when you select a different
printer???


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520326




All times are GMT +1. The time now is 07:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com