Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qTest", "c:\test.xls", False 'Declare and Start Microsoft Excel 2000. Dim AppExcel As Object, WB As Object Set AppExcel = CreateObject("Excel.Application") Set WB = AppExcel.Workbooks.Open("c:\test.xls") AppExcel.Visible = True WB.Columns.AutoFit WB.Sheets(1).pivottables(1).Refresh 'Quit Microsoft Excel and release the object variable. AppExcel.Quit Set AppExcel = Nothing Set WB = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MS Access 2013 field type short text default value||5||27|
|Formula to pull out part of text in cell||3||24|
|Turning off query prompts on runtime version of Access 2016||5||18|
|ms/link form - subform field not recognised||3||16|