Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108762

Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it?

Show all headers | View raw

> On 4/15/2016 11:01 PM, GS wrote:
>>> On 4/15/2016 6:07 PM, GS wrote:
>>>> Is there any reason you can't use a worksheet to format your 
>>>> report?
>>>
>>> I will have multiple pages and I don't know how to paginate an 
>>> Excel
>>> worksheet. Can I embed pagebreaks in the worksheet? If so that 
>>> might
>>> work.
>>
>> Yes, you absolutely can place manual pagebreaks. In v2003< it's on 
>> the
>> Insert menu. In v2007> it's on the Page Layout tab. One caveat is 
>> you
>> need to pay attention that your manual pagebreaks aren't screwed up 
>> by
>> the default ones, meaning you may have to remove some so your page
>> 'flow' goes how you want. Once you PrintPreview, the print_area and
>> pagebreaks appear on your worksheet and so can use these as guides 
>> for
>> setting pagination.
>>
>> For viewing in the worksheet you can turn off gridlines so your 
>> page
>> appears like a word processor (sort of).
>
> Thank you for the detailed explanation. I'll look into this and see 
> if this is easier than automating Word outside of the workbook.

I find it much easier, but it took some getting used to initially. 
Figuring out page width will be your biggest challenge, followed by 
whether to use a single wide column for text, or let it run over 
several columns.

I find designing forms (static or interactive) is easier with a graph 
paper grid layout so cells are square. Doing userguides/manuals using 
multiple fixed col widths works well if there's lots of images to 
arrange with text. Graphs and charts are easier too since their source 
data can be outside the Print_Area boundaries, and they update 
automatically without any OLE trickery between documents involved.

Output (for me) is usually PDF for distribution as read-only reports, 
but direct hard copy printouts are also easy. I find Excel outputs 
smaller PDF files than Word does, generally speaking. (Multi-page PDFs 
usually get treeview style navigation added via Adobe Acrobat)

The largest page layout I've done is 2-sided tabloid size paper for 
making 4 or 6 page brochures after folding.

Another benefit is the ability to store series/period reports in a 
single workbook on single or separate sheets. (Not to mention more 
easily share data between them without external refs!)

Over the years I've made a deliberate effort to eliminate need for 
using Word for anything, and so far haven't found any exceptions to 
using Excel for just about everything!

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-15 16:40 -0700
  Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-15 21:07 -0400
    Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-15 22:37 -0700
      Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-16 02:01 -0400
        Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-15 23:39 -0700
          Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-16 06:34 -0400
  Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-16 07:21 -0400
    Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-16 22:14 -0700

csiph-web