请教高手:vb连接Excel,如何合并单元格????

 所属目录:Java   |   类型:技术问答   |   时间:2007-05-21
 问题:

我想用vb对excel的单元格进行合并,程序如下,运行后没有反映,请教是哪里出错了?  
   
  sub   mergecell(cellrange   as   string)  
  range(cellrange).select  
  selection.mergecells   =   true  
  selection.horizontalalignment   =   xlcenter  
  selection.verticalalignment   =   xlcenter  
  end   sub  
   
  private   sub   command11_click()  
      dim   xlapp   as   excel.application  
      dim   xlbook   as   excel.workbook  
      dim   xlsheet   as   excel.worksheet  
           
      set   xlapp   =   createobject("excel.application")    
      xlapp.visible   =   true    
      set   xlbook   =   xlapp.workbooks.open("d:12345.xls")    
      set   xlsheet   =   xlbook.worksheets(1)    
      xlsheet.activate  
   
      mergecell   "a1:a5"  
      xlapp.visible   =   true  
      set   xlapp   =   nothing  
      set   xlbook   =   nothing  
      set   xlsheet   =   nothing  
  end   sub  
   
 

.

· 网友精彩回答:

处理 SSI 文件时出错
© 2006-2008 All Rights Reserved