Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Dim acExcel, wb Dim xlPath xlPath = "F:\xxxxxx" Set acExcel = CreateObject("Excel.Application") acExcel.Visible = True Set wb = acExcel.Workbooks.Open(Filename:=xlPath, UpdateLinks:=xlUpdateLinksAlways) With wb.worksheets("Sheet1") '--------work on the data------------- End With wb.Close False Set wb = Nothing acExcel.Quit Set acExcel = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.