请教各位:在VB中调用EXCEL后,如何让EXCEL提示的信息屏蔽掉.在线等候.谢谢!!! 我沒見過這種情況,你要提問最好貼一段代碼出來。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我沒見過這種情況,你把你的代碼寫來看看吧 For i = 0 To MSHFlexGrid1.Rows - 1 MSHFlexGrid1.Row = i For j = 0 To MSHFlexGrid1.Cols - 1 MSHFlexGrid1.Col = j If IsNull(MSHFlexGrid1.Text) = False Then xlSheet.Cells(i + 3, j + 1) = MSHFlexGrid1.Text End If Next j Next i '--------------------------------- With xlSheet .Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).BorderAround LineStyle:=xlContinuous, Weight:=xlHairline .Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).Borders(xlInsideHorizontal).LineStyle = xlContinuous .Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).Borders(xlInsideHorizontal).Weight = xlHairline .Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).Borders(xlInsideVertical).LineStyle = xlContinuous .Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).Borders(xlInsideVertical).Weight = xlHairline End With xx = "a" & 3 yy = "b" & 4 xlSheet.Range(xx & ":" & yy).MergeCells = True xlSheet.Range("a5:a8").MergeCells = True' Dim strRange As String' strRange = "A5:A8"' xlSheet.Range(strRange).Merge' xlSheet.Range(strRange).HorizontalAlignment = xlCenter' xlSheet.Range(strRange).VerticalAlignment = xlCenter xlSheet.Range("a9:a12").MergeCells = True xlSheet.Range("a13:a16").MergeCells = True xlSheet.Range("a17:a20").MergeCells = True就是上述代码.希望你们看过之后,给与答案.我在线等候. 如何检测打开的TXT文档为空? 简单问题============关于获取窗体大小API函数=====================马上给分 用 URLDownloadToFile 下载资料的问题 用vb做个连接网站的快捷方式 紧急求援 多线程的疑问 一首很不错的改编歌曲——给布什 散5500分!被封杀1年积攒的,下午5点前结贴,只给想做版主的! 不知这个问题难不难!! 请问怎样清空一个ACCESS2000数据库中的表,怎样用SQL建立自动编号字段? 怎样彻底从数据库中删除纪录? 如何利用VB控制EXCEL进行同一工作簿内工作表的复制,谢谢.
MSHFlexGrid1.Row = i
For j = 0 To MSHFlexGrid1.Cols - 1
MSHFlexGrid1.Col = j
If IsNull(MSHFlexGrid1.Text) = False Then
xlSheet.Cells(i + 3, j + 1) = MSHFlexGrid1.Text
End If
Next j
Next i
'---------------------------------
With xlSheet
.Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).BorderAround LineStyle:=xlContinuous, Weight:=xlHairline
.Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).Borders(xlInsideHorizontal).LineStyle = xlContinuous
.Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).Borders(xlInsideHorizontal).Weight = xlHairline
.Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).Borders(xlInsideVertical).LineStyle = xlContinuous
.Range(.Cells(3, 1), .Cells(MSHFlexGrid1.Rows + 2, 14)).Borders(xlInsideVertical).Weight = xlHairline
End With
xx = "a" & 3
yy = "b" & 4
xlSheet.Range(xx & ":" & yy).MergeCells = True
xlSheet.Range("a5:a8").MergeCells = True
' Dim strRange As String
' strRange = "A5:A8"
' xlSheet.Range(strRange).Merge
' xlSheet.Range(strRange).HorizontalAlignment = xlCenter
' xlSheet.Range(strRange).VerticalAlignment = xlCenter
xlSheet.Range("a9:a12").MergeCells = True
xlSheet.Range("a13:a16").MergeCells = True
xlSheet.Range("a17:a20").MergeCells = True
就是上述代码.希望你们看过之后,给与答案.我在线等候.