How to Copy excel formulas from one excel to other

[Syam]

Can anybody suggest me how to copy excel formulas from a range and past
it to another excel programatically using c#. Any suggestionwill b
appreciative

 

[merjet]

This url might help:
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/7481e412-5a7f-4251-9483-9ffd55b59caa/

 

[GS]

Syam has brought this to us :

Can anybody suggest me how to copy excel formulas from a range and paste
it to another excel programatically using c#. Any suggestionwill be
appreciative.

Try...
{
oXLApp.Range("TargetAddressGoesHere") =
oXLApp.Range("SourceAddressGoesHere");
}

 

[GS]

Corrected to reflect copying formulas instead of values...

Try...
{

oXLApp.Range("TargetAddressGoesHere").Formula =
oXLApp.Range("SourceAddressGoesHere").Formula;

 

[GS]

Oops.., syntax error correction...

Corrected to reflect copying formulas instead of values...

oXLApp.Range("TargetAddressGoesHere").Formula ==
oXLApp.Range("SourceAddressGoesHere").Formula;
--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion