With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
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
|Replace NULL Value in Crosstab query with previous day data||6||28|
|selection of current record jumps to a non-selected record||8||34|
|Why doesn't duplicate values work on this spreadsheet?||6||31|
|Field Size - Double? Want to display 0||5||26|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!