Re: Page Break in Excel from VB 2005

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_email@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


.

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)