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.
Private Sub Command2_Click() DoCmd.OutputTo acOutputQuery, "Tickers for Exporting", acFormatXLSX, "\\nor-gs2-dc01\Redirected\xxxx\Desktop\Tickers for Exporting.xlsx", False Dim xlObj As Object Set xlObj = CreateObject("Excel.Application") xlObj.Workbooks.Open "\\nor-gs2-dc01\Redirected\xxxx\Desktop\Tickers for Exporting.xlsx" With xlObj .activeworkbook.SaveAs "\\nor-gs2-dc01\Redirected\xxxx\Desktop\Tickers for Exporting.xls" End With xlObj.Quit Set xlObj = Nothing End Sub
|Excel highlight a cell based on input from another cell||3||14|
|Excel VBA Find Lowest Column number in any range selection||5||20|
|sumifs excel 2013||3||14|
|VBA or formula to pick random selection of numbers except those with date assigned||7||16|