I am running some code that export qry result to an excel application but want to turn off the "Application.Calculation" in excel prior to the export.
i cannot figure out the correct syntax.
here is the portion of the modules code definin my Excel app, workbook worksheet etc.
i've tried
and
thanks for the help
Tuk
i cannot figure out the correct syntax.
here is the portion of the modules code definin my Excel app, workbook worksheet etc.
Code:
Dim xlx As Object, xlw As Object, xls As Object, xlc As Object
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim blnEXCEL As Boolean, blnHeaderRow As Boolean
blnEXCEL = False
' Replace True with False if you do not want the first row of
' the worksheet to be a header row (the names of the fields
' from the recordset)
blnHeaderRow = False
' Establish an EXCEL application object
On Error Resume Next
Set xlx = GetObject(, "Excel.Application")
If Err.Number <> 0 Then
Set xlx = CreateObject("Excel.Application")
blnEXCEL = True
End If
Err.Clear
On Error GoTo 0
' Change True to False if you do not want the workbook to be
' visible when the code is running
xlx.Visible = True
i've tried
Code:
'turn off calcs
excel.Application.Calculation = xlManual
and
Code:
xlx.Calculation = xlManual
thanks for the help
Tuk