Re: Page Break in Excel from VB 2005

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

  • Record Macro in Excel 2007 not recording everything
    ... the 'Record Macro' functionality is not so complete anymore. ... The result is the insert & save sheet code. ... I hope this is a setting because otherwise I will go back to Excel ... I do a lot of vba automation from VB6 apps and the 'record macro' ...
    (microsoft.public.excel)
  • Re: Excel Automation
    ... I used the Record Macro function to record inputing names in 2 different ... where you can use Excel or Word as your UI. ... > assemblies, a whole new world of problems opens up, so I don't recommend it. ... PIAs save you all this hassle and more. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: opening files and applications, same as if one did it by hand
    ... You need to post your question in a newsgroup ... using record macro and then adding more code. ... In either Word or Excel, when I edit macros, and look at help ... of the Office products. ...
    (microsoft.public.vb.general.discussion)
  • Reading Material: Excel VBA
    ... Can anyone please recommend a book or books for Excel VBA ... I can use the Excel "Record Macro" without any problems and can get some ... Query the entire worksheet for data then I have input from an input box. ...
    (microsoft.public.excel.misc)
  • Re: Formating Excel via Access
    ... Go into Excel and start Record Macro. ... Go to edit macro and you will see the ... "Kevin" wrote in message ...
    (microsoft.public.access.formscoding)