VB 2005中的Excel分页符 [英] Page Break in Excel from VB 2005

问题描述

我正在使用VB 2005和Excel 2007，并且无法弄清楚如何在第72行之前插入页面

中断。我已经尝试了几种方法但总是得到异常

错误。


提前致谢。

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.

推荐答案

7月9月12日下午12点24分，Stephen Plotnick < ... @ attglobal.netwrote：

On Jul 9, 12:24 pm, "Stephen Plotnick" <[e-mail]:

我正在使用VB 2005和Excel 2007而无法弄清楚如何插入页面

在第72行之前突破。我已经尝试了几种方法但总是得到一个例外

错误。


提前谢谢。

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.

我建议你使用记录宏和记录宏。 Excel的功能

并记录添加分页符的宏。然后你只需要
将经典的vb代码修改为Visual Basic .Net并在你的

应用程序中使用它。


谢谢，


Seth Rowe

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

Seth，


谢谢回复。这就是我所做的，我总是在

运行时获得一个例外。我用Google搜索，似乎已经尝试了所有内容，而且似乎从来没有工作过。


Steve

" rowe_newsgroups" < ro ******** @ yahoo.com在留言中写道

新闻：11 ********************** @ 22g2000hsm.googlegro ups.com ...

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" <ro********@yahoo.comwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...

7月9日下午12:24，Stephen Plotnick < ... @ attglobal.netwrote：

On Jul 9, 12:24 pm, "Stephen Plotnick" <[e-mail]:

>我正在使用VB 2005和Excel 2007而无法弄清楚如何插入
页面
在第72行之前休息。我已经尝试了几种方法但总是出现异常
错误。

提前致谢。

>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.

我建议你使用记录宏和记录宏。 Excel的功能

并记录添加分页符的宏。然后你只需要
将经典的vb代码修改为Visual Basic .Net并在你的

应用程序中使用它。


谢谢，


Seth Rowe

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

7月9日下午12:43，Stephen Plotnick < ... ... @ attglobal.netwrote：

On Jul 9, 12:43 pm, "Stephen Plotnick" <[e-mail]:

Seth，


谢谢回复。这就是我所做的，我总是在

运行时获得一个例外。我用谷歌搜索，似乎已经尝试了所有的东西，它似乎永远不会工作。


Steve" rowe_newsgroups" < rowe_em ... @ yahoo.com写了留言


新闻：11 ********************** @ 22g2000hsm.googlegro ups.com ...

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" <[e-mail] in message

news:11**********************@22g2000hsm.googlegro ups.com...

7月9日下午12:24，Stephen Plotnick < ... @ attglobal.netwrote：

On Jul 9, 12:24 pm, "Stephen Plotnick" <[e-mail]:

我正在使用VB 2005和Excel 2007而无法弄清楚如何插入

页

在第72行之前休息。我已经尝试了几种方法但总是得到一个例外

错误。

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.

我建议你使用记录宏和记录宏。 Excel的功能

并记录添加分页符的宏。然后你只需要将
修改为Visual Basic .Net的经典vb代码并在你的

应用程序中使用它。

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

Seth Rowe

发布你的代码。


谢谢，


Seth Rowe

Post your code.

Thanks,

Seth Rowe

这篇关于VB 2005中的Excel分页符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！