Imports Microsoft.Office.Core Imports Microsoft.Office.Interop Impor开发者_C百科ts Microsoft.Office.Interop.Excel
I have this code:
Dim oApp As New Excel.Application()
Dim wb As Excel.Workbook
wb = oApp.Workbooks.Open("D:\NoriaMail\23120011\LPO Summary per Month_View 3 - AllMonths.xlsx")
can anybody tell me how can I assign value to wb witout open the file (I want another function to give wb value without open the file)
thank's for helpWhat type of value do you want to "assign"? Some sort of metadata? In my experience, your code above is the correct way to open the file; from there, you can begin manipulating the file.
精彩评论