Click here to Skip to main content
15,923,689 members
Home / Discussions / C#
   

C#

 
AnswerRe: New Line in Textbox Pin
malikjhangirahmed@hotmail.com4-Jun-06 22:26
malikjhangirahmed@hotmail.com4-Jun-06 22:26 
GeneralRe: New Line in Textbox Pin
Gazoline Speed4-Jun-06 23:09
Gazoline Speed4-Jun-06 23:09 
QuestionMini toolbar in C# Pin
hschutte4-Jun-06 21:13
hschutte4-Jun-06 21:13 
Question"generating rprts through c#" Pin
ravikiranreddydharmannagari4-Jun-06 21:00
ravikiranreddydharmannagari4-Jun-06 21:00 
AnswerRe: "generating rprts through c#" Pin
Guffa4-Jun-06 22:23
Guffa4-Jun-06 22:23 
Questionconcurrency + ms access Pin
g00fyman4-Jun-06 20:07
g00fyman4-Jun-06 20:07 
QuestionCalling UnManaged Code Pin
satsumatable4-Jun-06 19:50
satsumatable4-Jun-06 19:50 
QuestionHow to copy data from one excel workbook to another Pin
sydney_sider4-Jun-06 18:05
sydney_sider4-Jun-06 18:05 
Hi all

Just for background information, I'm only just starting out with .NEt C# programming on Excel, which means that i'm not very good at all.. [=o))..

I am trying to write a simple C# program to open up 2 excel workbooks and copy the data from one Excel workbook to another. This process is required to be repeated for more than 20times, for 20 different set of workbooks ofcourse.

I have tried out 2 different methods but both methods take extremely long to complete. I do not understand why as if I do it manually in Excel, the selecting, copying & pasting processes takes 2 seconds to complete. While with the C# program, these processes take about 30 seconds to complete.

Method 1
Create a macro for copying & pasting. Simply pass through the Selection range for copying and pasting. These macros, when run inside Excel, is extremely fast. However when called from the C# program, these macros take forever to complete.

method 2
inside the C# program, use the Range[].Copy method. This takes forever to complete as well.

Can you guys please help me out with this one. That would be absolutely great.

Thanks guys

Kind regards

Sydney_Sider
AnswerRe: How to copy data from one excel workbook to another Pin
Tamimi - Code4-Jun-06 19:25
Tamimi - Code4-Jun-06 19:25 
GeneralRe: How to copy data from one excel workbook to another Pin
sydney_sider4-Jun-06 21:20
sydney_sider4-Jun-06 21:20 
QuestionImage in PictureBox is not showing in run time. [modified] Pin
emran8344-Jun-06 15:26
emran8344-Jun-06 15:26 
AnswerRe: Image in PictureBox is not showing in run time. [modified] Pin
AhsanS5-Jun-06 3:51
AhsanS5-Jun-06 3:51 
QuestionOutlook context menu item Pin
Usman Rauf4-Jun-06 10:47
Usman Rauf4-Jun-06 10:47 
QuestionERROR_HANDLER Pin
Bedevian4-Jun-06 9:39
Bedevian4-Jun-06 9:39 
AnswerRe: ERROR_HANDLER Pin
Guffa4-Jun-06 10:21
Guffa4-Jun-06 10:21 
QuestionHelp for serial communication. Pin
AhsanS4-Jun-06 9:38
AhsanS4-Jun-06 9:38 
AnswerRe: Help for serial communication. Pin
Ed.Poore4-Jun-06 11:16
Ed.Poore4-Jun-06 11:16 
GeneralRe: Help for serial communication. Pin
AhsanS4-Jun-06 21:45
AhsanS4-Jun-06 21:45 
GeneralRe: Help for serial communication. Pin
Ed.Poore5-Jun-06 1:19
Ed.Poore5-Jun-06 1:19 
GeneralRe: Help for serial communication. Pin
Ed.Poore5-Jun-06 1:30
Ed.Poore5-Jun-06 1:30 
Questioni use now a parameterized query but still get an error [modified] Pin
TheBeginner774-Jun-06 8:56
TheBeginner774-Jun-06 8:56 
AnswerRe: i use now a parameterized query but still get an error Pin
NaNg152414-Jun-06 9:30
NaNg152414-Jun-06 9:30 
AnswerRe: i use now a parameterized query but still get an error [modified] Pin
Guffa4-Jun-06 10:23
Guffa4-Jun-06 10:23 
AnswerRe: i use now a parameterized query but still get an error Pin
Rob Graham4-Jun-06 11:47
Rob Graham4-Jun-06 11:47 
Questiona special Format For MaskedTextBox [modified] Pin
mostafa_h4-Jun-06 8:53
mostafa_h4-Jun-06 8:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.