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 wrote:

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