Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 812
Default How to Copy excel formulas from one excel to other

This url might help:
http://social.msdn.microsoft.com/For...-9ffd55b59caa/

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to copy formulas using $ in Excel clischak Excel Worksheet Functions 4 December 14th 06 05:44 PM
copy formulas without scrolling, excel 2003. Shub New Users to Excel 2 June 25th 06 07:46 AM
hOW DO i COPY FORMULAS FROM ONE SPREADSHEET TO ANOTHER IN EXCEL Isabel Excel Discussion (Misc queries) 1 May 1st 06 06:20 PM
how can i get formulas in excel to copy and paste? bman Excel Worksheet Functions 1 October 3rd 05 04:15 PM
How do I save a copy of an excel file without the formulas? Saving Excel File without Formula Excel Worksheet Functions 1 February 14th 05 08:55 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"