VBS replace function

[oso_togari]

Hello all

im making a VBS to manipulate excel file..
in one part i fill cells with formulas:

objexcel.Range("B2").formula = "=espacios(A2)"
objExcel.Range("B2","B" & ws.Cells(ws.Rows.Count, 1).End(xlUp).Row).FillDown

but in the excel the formulas appears with "@" preceeding the function.
if i manually delete the "@" in the excel it works as expected...but i want to know how to replace in vbs

im using:
objExcel.Range("B:D").Replace "@","
and
objExcel.Range("B:D").Replace "@","",,,,,,1
objExcel.Range("B:D").Replace "@","",,,,,,xlreplceformula2 (this come from a macro recording)

but no luck...any ideas?

 

[Fluff]

Try using Fornual2 rather than formula

objExcel.Range("B2").Formula2 = "=espacios(A2)"

 

[oso_togari]

Thank you

it partially works!! but the excel still remains with #¿NOMBRE? value....only if enter the cell and do a simple enter...then it takes the formula correctly...

why this??

 

[Fluff]

What if you try

objExcel.Range("B2").Formula2 = "=Trim(A2)"

 

[oso_togari]

What if you try

objExcel.Range("B2").Formula2 = "=Trim(A2)"

PERFECT! i think i have to program the functions in the same langiaje you have the excel
now works like a charm!
thank you

 

[Fluff]

If you want to use the excel language version try

.Formula2Local