Hello everybody.
I have to create from access 97 a workbook with advanced adds with a typical
code:
Dim XL As Excel.Application, WKB As Workbook, SHT As Worksheet
Set XL = New Excel.Application
With XL
.Visible = True
Set WKB = .Workbooks.Add(xlWBATWorksheet)
End With
.....
CopyFromRecordset RS
......

and I would calculate work days from two dates with function:
Cells(4,17).Select
Cells(4, 17).FormulaR1C1 = "=NETWORKDAYS(R[1]C[-8],RC[-7],Holidays)"

but Excel return error #NAME in the cell, also if options "advanced adds"
are selected in the workbook.
Therefore, I have deselected these options, closed the window, re-open
window for re-selecting advanced options, then, after selected cell, I pushed
function button (fx) and confirmed: function runned exactly!
I am very confused about this fenomena: someone help me?
Is another way to create a workbook ?
Many thanks in advance.


--
Giangi E.D.
Italy