ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to Copy excel formulas from one excel to other (https://www.excelbanter.com/excel-programming/394001-how-copy-excel-formulas-one-excel-other.html)

Syam

How to Copy excel formulas from one excel to other
 
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.

merjet

How to Copy excel formulas from one excel to other
 
This url might help:
http://social.msdn.microsoft.com/For...-9ffd55b59caa/


GS[_2_]

How to Copy excel formulas from one excel to other
 
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");
}

--
Garry

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



GS[_2_]

How to Copy excel formulas from one excel to other
 
Corrected to reflect copying formulas instead of values...

Try...
{

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



GS[_2_]

How to Copy excel formulas from one excel to other
 
Oops.., syntax error correction...

Corrected to reflect copying formulas instead of values...

Try...
{

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




All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com