Click here to Skip to main content
15,887,214 members
Home / Discussions / C#
   

C#

 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
MumbleB2-Jul-09 9:22
MumbleB2-Jul-09 9:22 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
Harry6662-Jul-09 13:58
Harry6662-Jul-09 13:58 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
MumbleB2-Jul-09 22:14
MumbleB2-Jul-09 22:14 
GeneralRe: exception trying to insert a range to an Excelsheet Pin
Harry6664-Jul-09 0:57
Harry6664-Jul-09 0:57 
Generalstill trying to insert a range to an Excelsheet Pin
Harry6664-Jul-09 4:14
Harry6664-Jul-09 4:14 
GeneralRe: still trying to insert a range to an Excelsheet Pin
MumbleB4-Jul-09 8:31
MumbleB4-Jul-09 8:31 
GeneralRe: still trying to insert a range to an Excelsheet Pin
Harry6665-Jul-09 4:38
Harry6665-Jul-09 4:38 
GeneralUsing a makro Pin
Harry6665-Jul-09 6:04
Harry6665-Jul-09 6:04 
Muchas gracias hombre! Thumbs Up | :thumbsup:

You gave me a good hint. This C#-code really made me mad! (I still don't know how to solve my problem in C#). But I told you that I'm gonna use a makro and call this by...

myWorkbook.Modules.Application.Run("AddLine", arg1, arg2, arg3, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,     Type.Missing, Type.Missing, Type.Missing);

and this is the simple makro:
Public Function AddLine(arg1 As String, arg2 As Integer, arg3 As Integer)
      Sheets(arg1).Select
      Rows(arg2 & ":" & arg3).Select
      Selection.Copy
      Selection.Insert Shift:=xlDown
End Function

so I'm able to select any worksheet with its name (arg1) and explicitly which rows to copy   Smile | :)

As a programmer I really would like to know how to do this in C#, but it took me a whole week and cost me my last hairs Sigh | :sigh: and still the C#-code does not work well, but I'm quite fine with this makro-solution.
Now, I am relieved. Cool | :cool:
Thanks a lot! Rose | [Rose] Thumbs Up | :thumbsup:
Harry

no plan,
no signature

GeneralRe: still trying to insert a range to an Excelsheet Pin
MumbleB6-Jul-09 19:16
MumbleB6-Jul-09 19:16 
GeneralRe: still trying to insert a range to an Excelsheet Pin
Harry6669-Jul-09 3:32
Harry6669-Jul-09 3:32 
QuestionDowloading file, web aplication and C# Pin
hoshyarD2-Jul-09 0:34
hoshyarD2-Jul-09 0:34 
AnswerRe: Dowloading file, web aplication and C# Pin
Manas Bhardwaj2-Jul-09 0:36
professionalManas Bhardwaj2-Jul-09 0:36 
QuestionVista/Win7 Gadget's Flyout. Pin
Supriya Tonape2-Jul-09 0:30
Supriya Tonape2-Jul-09 0:30 
AnswerRe: Vista/Win7 Gadget's Flyout. Pin
musefan2-Jul-09 1:58
musefan2-Jul-09 1:58 
GeneralRe: Vista/Win7 Gadget's Flyout. Pin
Supriya Tonape2-Jul-09 6:38
Supriya Tonape2-Jul-09 6:38 
QuestionIndex was out of range. Must be non-negative and less than the size of the collection Pin
haleemasher2-Jul-09 0:22
haleemasher2-Jul-09 0:22 
AnswerRe: Index was out of range. Must be non-negative and less than the size of the collection Pin
N a v a n e e t h2-Jul-09 0:28
N a v a n e e t h2-Jul-09 0:28 
GeneralRe: Index was out of range. Must be non-negative and less than the size of the collection Pin
haleemasher2-Jul-09 0:37
haleemasher2-Jul-09 0:37 
GeneralRe: Index was out of range. Must be non-negative and less than the size of the collection Pin
Luc Pattyn2-Jul-09 0:54
sitebuilderLuc Pattyn2-Jul-09 0:54 
QuestionNonSerialized property. Pin
johnnycastle2-Jul-09 0:19
johnnycastle2-Jul-09 0:19 
AnswerRe: NonSerialized property. Pin
Keith Barrow2-Jul-09 1:56
professionalKeith Barrow2-Jul-09 1:56 
GeneralRe: NonSerialized property. Pin
dojohansen2-Jul-09 2:21
dojohansen2-Jul-09 2:21 
AnswerRe: NonSerialized property. Pin
dojohansen2-Jul-09 2:04
dojohansen2-Jul-09 2:04 
AnswerRe: NonSerialized property. Pin
johnnycastle2-Jul-09 2:43
johnnycastle2-Jul-09 2:43 
QuestionUI Delay [modified] Pin
viciouskinid1-Jul-09 23:28
viciouskinid1-Jul-09 23:28 

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.