调整Excel表格的列宽

[glenn1986]

请问，可以用ActiveX使Execl表格统一列宽或者自动调整为最适合列宽吗？

[huyu · Accepted solution]

you can use the properties and methods of Columns to adapt it

Message Edited by NIhuyu on 02-21-2010 06:49 PM

[zou]

Is there a way to specift column index?

[glenn1986]

怎样调用属性和方法打开一个已存在的excel表格呢？

谢谢。

[huyu]

---

zou wrote:

Is there a way to specift column index?

---

of course yes, you should set a cell range in _Worksheet, any range of the specified column, then follow the diagram below

Message Edited by NIhuyu on 02-23-2010 06:41 PM

[huyu]

---

glenn1986 wrote:

怎样调用属性和方法打开一个已存在的excel表格呢？

谢谢。

---

diagram as below

[glenn1986]

能帮我看看这个程序哪里有问题吗？

每次运行，excel表格不能自动保存并推出。

谢谢。