AsFormula

[Joney_Hell]

Hi!
How to write such a formula in a cell?
Dir:= 'C:/dir';
File:= 'File.xlsx';

xlSGrid.xls.Sheets[4].AsFormula[0,0]:=Dir+'\['+File+']sheet''!D7';



thank

[larsa]

Hello

Write the formula in Excel, save the file and open it then with XLSReadWriteII and check what is written in the cell.