[AccessD] Programmatically change cell formulae in Ecel

Bizarrely enough, this appears to be the answer. Those accursed single
quotes! Who knew?

Arthur

On Nov 28, 2007 3:37 PM, O'Connor, Patricia (OTDA)
<Patricia.O'Connor at otda.state.ny.us>
wrote:

> hi Arthur
> Sorry I am not at work to really try this out before sending a answer
> if I had a copy of the excel spreadsheet I could play with it a bit more
> and test
> But when building strings and I tend to put the " and ' in using the CHR()
>  and have gotten around many problems
>
> Dim strFormula as String
> strFormula = CHR(34) & "=VBLOOKUP(A6," & CHR(39) &
> strFormula = strFormula & "S:\Lgroup\Fundacct\Excel\!INVPORT\CSV
> FILES\Sep07\[# of securities.xls]SOI"
> strFormula = strFormula & CHR(39) & "!$B$3:$C$100,2,TRUE)" & CHR(34)
>
> or
> strFormula =  "=VBLOOKUP(A6," & CHR(39) &
> strFormula = strFormula & "S:\Lgroup\Fundacct\Excel\!INVPORT\CSV
> FILES\Sep07\[# of securities.xls]SOI"
> strFormula = strFormula & CHR(39) & "!$B$3:$C$100,2,TRUE)"
>
> HTH
> Patti
>
>