Wednesday, June 2, 2010

Third Party Sick Pay Taxable



when we are generating a report in excel from. Net we have to put the names of the columns and would be too Tedis enter the locations of the columns one by one, ie hacierndo a list of columns

column (1) = "A"
098. column (2) = "B"
099. column (3) = "C"
100. column (4) = "D"
101. column (5) = "E"
102. column (6) = "F"
103. column (7) = "G"

why I leave here this code: where the chain vector contains the names of the columns that are going to admit, but as locations realize the operation with a cycle of size name to be placed

For i = 1 To cadena.Length - 1
Then If n = 90 n = 65
m = 64
If End If m> 0 Then
m + = 1
xlApp.Range (Chr (n) & Chr (m) & "7"). Value = string (i). ToString () Else
n + = 1
xlApp.Range (Chr (n) & "7"). Value = string (i). ToString () End If
Next

hope you make it functional

0 comments:

Post a Comment