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" <the...@attglobal.netwrote:
我正在使用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" <the...@attglobal.netwrote:
>我正在使用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" <the...@attglobal.netwrote:
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" <rowe_em...@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" <the...@attglobal.netwrote:
我正在使用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屋!