Print format
 

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,

Print format
 

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

Print format
 

Thanks for the tip Dave I appreciate it.
Cheers

"Dave Peterson" wrote in message
...
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