How to Copy output to specific cells in excel?

[sree161]

Hi,

i have a code which generates two numeric outputs.i have to save them in excel.
Is there any way to export them to specific cells in excel???

[KickStarter15]

@sree161, Yes, you can use _Excel_RangeWrite() for that.

[sree161]

But it doen't tell how to paste it in specific cell??
any special command to do that??

[JoHanatCent]

 _Excel_RangeWrite()

With parameter $vRange you specify for example cell "c3"

 

 

[KickStarter15]

@sree161, try checking with help file and see all the parameters you need for writing in excel.

[sree161]

Hi all, 

Thanks for the suggestions. I have learnt to use all those parameters.

I am struck with a problem.

I am running a loop, which gives 2 values at the end and have to copy this to excel.

Each time the loop gives a output I am able to paste in A2 , B2 as I set those 

How can I automatically jump to next line i.e A3 ,B3 for next loop output???

Any logics plzz??

Thanks in advance,

Sree161

 

[water]

Use a counter (e.g. $i) that starts with 0 and is incremented each time before you write new values.
Set the target cell to write to like this:

"A" & $i

 

[sree161]

2 hours ago, water said:

Use a counter (e.g. $i) that starts with 0 and is incremented each time before you write new values.
Set the target cell to write to like this:

"A" & $i

 

This worked. Thanks a lot

[water]