Print format

[CAM]

Hello,

I am using Excel 2007 I have a folder call "C:\Test" containing about 25
Excel files. What I want to do is to have a way that all 25 Excel print in
Landscape and have the margin all around .5 (top, left,right,bottom). How
do I could that? any tips will be appreciated. Thank you in advance.

cheers,

 

[Dave Peterson]

Check your other post.

Record a macro that does what you want against a test worksheet. Then add that
code to the previous response.

 

[CAM]

Thanks for the tip Dave I appreciate it.
Cheers

Check your other post.

Record a macro that does what you want against a test worksheet. Then add
that
code to the previous response.