Insert data in different excel sheet

[tnerurkar]

Hi,

How can insert data in different sheets in one excel using D2k?

Thanx in Advance.

regards
Tushar

 

[taupirho]

There are a few ways this could be done. Simplest way - in my opinion - is to use DDE as you are able to, among other things, run macros. The macros can do anything you want such as switching to a different sheet. See my article

http://the-big-o.port5.com/article3.shtml

for some pointers.

 

[tnerurkar]

Hi,

Thanks for the reply.

Can you please tell me how can I insert data in different sheet using DDE?

Thanks in advance
Regards
Tushar