Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
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
|A script to extract the important data and calculate if the amounts are correct||12||40|
|How calculate median||5||37|
|Dear Rgonzo please help making the code work in personal workbook to enforce it on any active workbook.||3||19|
|MS Access single form simultaneous memo field edit by several users||7||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!