Hello,
I'm using the web query function inside Excel 2003 to import tabular
data generated by a php file (also done by me).

I'd like to place some formulas inside the table generated by php and
up to now, i've been able to write directly to it and successfully
place those formulas inside my Excel document.

eg: "=20*A1" works perfectly and it's executed flawlessy in excel.

I need to go one step further: i need to create "relative positioned"
formulas inside the php, for example "[myposition+one column to the
right]".

Is that even possible in excel ?

Thanks in advance for any hint!

=20*INDIRECT(ADDRESS(ROW(),COLUMN()+1))

or

ActiveCell.FormulaR1C1 = "=RC[1]"

--
Regards,
Tom Ogilvy



"gareth jax" wrote in message
ups.com...
Hello,
I'm using the web query function inside Excel 2003 to import tabular
data generated by a php file (also done by me).

I'd like to place some formulas inside the table generated by php and
up to now, i've been able to write directly to it and successfully
place those formulas inside my Excel document.

eg: "=20*A1" works perfectly and it's executed flawlessy in excel.

I need to go one step further: i need to create "relative positioned"
formulas inside the php, for example "[myposition+one column to the
right]".

Is that even possible in excel ?

Thanks in advance for any hint!

By the way: internationalization!

I've tried your example ( =20*indirect(address(row();column()+10)) )
and it does not works, because my excel is in italian.
I had to translate the functions in italian language.
Is there a way to use only one language "format" ? (eg: english named
functions ).

Thanks again!

By the way: internationalization!

That is your job my friend. If you want an answer in italian, post in the
italian news group.

I already answered your email showing how to enter the formula with VBA
(formula written in US English).

--
Regards,
Tom Ogilvy

"gareth jax" wrote in message
ups.com...

By the way: internationalization!

I've tried your example ( =20*indirect(address(row();column()+10)) )
and it does not works, because my excel is in italian.
I had to translate the functions in italian language.
Is there a way to use only one language "format" ? (eg: english named
functions ).

Thanks again!