| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| After print preview it changes the format, what could it be? | Excel Discussion (Misc queries) | |||
| how to format the print? | Excel Programming | |||
| How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
| Print Format | Excel Programming | |||
| worksheet print format | Excel Worksheet Functions | |||
Linear Mode
