Re: Page Break in Excel from VB 2005

On Jul 9, 12:43 pm, "Stephen Plotnick" <the...@xxxxxxxxxxxxx> wrote:
Seth,

THanks for the reply. That is what I did and I always get an exception at
run time. I googled and seemed to have tried everything and it never seems
to work.

Steve"rowe_newsgroups" <rowe_em...@xxxxxxxxx> wrote in message

news:1183998991.748123.138610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

On Jul 9, 12:24 pm, "Stephen Plotnick" <the...@xxxxxxxxxxxxx> wrote:
I'm using VB 2005 and Excel 2007 and cannot figure out how to insert a
page
break before line 72. I've tried several ways but always get an exception
error.

Thanks in advance.

I would recommend you use the "Record Macro" functionality of Excel
and record a macro of you adding the pagebreak. Then you just have to
modify that classic vb code to Visual Basic .Net and use it in your
application.

Thanks,

Seth Rowe

Post your code.

Thanks,

Seth Rowe

.

Relevant Pages

  • Re: Plural of "still life"
    ... we don't modify the "f" in phrases like ... then, that one would indeed modify the "f" in red-roofed, if one said ... An exception to a general rule, indeed, but it's indubitably ...
    (alt.usage.english)
  • Re: scared about refrences...
    ... functions should not modify their caller's data. ... But notice that you only need a shallow copy, not a deep copy, because you ... If so, please post the exception. ... When it blows up, is there a lot of shrapnel, or just smoke and fire? ...
    (comp.lang.python)
  • Re: Re-raising exceptions with modified message
    ... No, I really want to modify the exception, supplementing its ... for the template developer. ... except ZeroDivisionError, e: ...
    (comp.lang.python)
  • Re: scared about refrences...
    ... functions should not modify their caller's data. ... for index, value in enumerate: ... But notice that you only need a shallow copy, not a deep copy, because you ... If so, please post the exception. ...
    (comp.lang.python)
  • Re: To use a file on another computer, must I copy it first?
    ... One possible exception is that two programs cannot modify the ... In other words, does Windows "lock" by ...
    (microsoft.public.windowsxp.network_web)