7,763
社区成员
发帖
与我相关
我的任务
分享
wb.Navigate ss
Private Sub wb_NavigateComplete2(ByVal pDisp As Object, URL As Variant)
On Error Resume Next
Set sDocument = pDisp.Document
sDocument.ActiveSheet.SetBackgroundPicture BackPic
End Sub
Option Explicit
Private xlsApp As Excel.Application 'Excel应用对象
Private xlsBook As Excel.Workbook 'Excel工作薄对象
Private xlsSheet As Excel.Worksheet 'Excel工作表对象
Private Sub Command1_Click()
Dim bolP As Boolean
bolP = funOpenExcelFile(xlsApp, xlsBook, xlsSheet, "D:\1.xls", "Sheet1", "", False)
xlsSheet.SetBackgroundPicture FileName:="C:\Documents and Settings\All Users\Documents\My Pictures\示例图片\Water lilies.jpg"
bolP = funCloseExcelFile(xlsApp, xlsBook, xlsSheet, True)
Me.WebBrowser1.Navigate "d:\1.xls"
End Sub
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
'函数功能:打开指定的Excel文件
'参数说明:xlsAPP:Excel应用对象
' :xlsWork:Excel工作薄对象
' :xlsSheet:Excel工作表对象
' :strExcelFile:Excel文件路径
' :strSheetName:工作表名
' :strPWD:密码
' :bolVisible:表的可见性
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Private Function funOpenExcelFile(ByRef xlsApp As Excel.Application, _
ByRef xlsWork As Excel.Workbook, _
ByRef xlsSheet As Excel.Worksheet, _
ByVal strExcelFile As String, _
ByVal strSheetName As String, _
ByVal strPWD As String, _
ByVal bolVisible As Boolean) As Boolean
On Error GoTo errFun
funOpenExcelFile = False
Set xlsApp = CreateObject("Excel.Application")
Set xlsWork = xlsApp.Workbooks.Open(strExcelFile, , False, , strPWD, strPWD)
Set xlsSheet = xlsBook.Worksheets(strSheetName)
xlsSheet.Activate
xlsApp.Visible = bolVisible
funOpenExcelFile = True
Exit Function
errFun:
funOpenExcelFile = False
End Function
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
'函数功能:关闭指定的Excel文件
'参数说明:xlsAPP:Excel应用对象
' :xlsWork:Excel工作薄对象
' :xlsSheet:Excel工作表对象
' :bolSave:是否保存
'%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Private Function funCloseExcelFile(ByRef xlsApp As Excel.Application, _
ByRef xlsWork As Excel.Workbook, _
ByRef xlsSheet As Excel.Worksheet, _
ByVal bolSave As Boolean) As Boolean
On Error GoTo errFun
If bolSave Then xlsBook.Save
Set xlsSheet = Nothing
xlsBook.Close
Set xlsBook = Nothing
Set xlsApp = Nothing
funCloseExcelFile = True
Exit Function
errFun:
funCloseExcelFile = False
End Function