好像不行。 Dim objexcel As Object Dim objwkbook As Object Dim objwksheet As Object Set objexcel = CreateObject("Excel.application") Set objwkbook = objexcel.workbooks 'objwkbook.open ("c:\rxreports\xls400rxx.csv") objwkbook.open ("c:\program files\microsoft_ office\office\xlstart\report400.xla") objexcel.Visible = True 这么写吗?但我打不开excel。
Private xlSheet As Excel.Worksheet Private xlApp As Excel.Application Private xlBook As Excel.WorkbookSet xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Open("c:\program files\microsoft_ office\office\xlstart\report400.xla") Set xlSheet = xlBook.Worksheets(1) xlSheet.Activate xlApp.Visible = False
Dim objexcel As Object
Dim objwkbook As Object
Dim objwksheet As Object
Set objexcel = CreateObject("Excel.application")
Set objwkbook = objexcel.workbooks
'objwkbook.open ("c:\rxreports\xls400rxx.csv")
objwkbook.open ("c:\program files\microsoft_ office\office\xlstart\report400.xla")
objexcel.Visible = True
这么写吗?但我打不开excel。
Private xlApp As Excel.Application
Private xlBook As Excel.WorkbookSet xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Open("c:\program files\microsoft_ office\office\xlstart\report400.xla")
Set xlSheet = xlBook.Worksheets(1)
xlSheet.Activate
xlApp.Visible = False