Automating an excel sheet through access - problem with formula

[UHNSTrust]

Apostrophe added during code

--------------------------------------------------------------------------------

I am trying to create an excel file from code within an Access database.

When I use the following line in my code it works but comes out as =Sum('D22':'D35')

.ActiveSheet.Range("D" & x).FormulaR1C1 = "=SUM(D22:D" & x - 1 & ")"

The apostrophes return #NAME? error.

Can somebody help as to what I should be putting in my code to stop the apostrophes?

Thanks in advance

Jonathan

 

[UHNSTrust]

I have figured this out using Row and Column references insted of cells.

Thanks to anybody who had a look.

Jonathan

 

[UHNSTrust]

I have figured this out using Row and Column references instead of cells.

Thanks to anybody who had a look.

Jonathan

 

[PHV]

Bottom line:
don't use A1 notation for the Formula.R1C1 property ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886