Dim R3Table As Object
Dim wordTbi As Object
Public Sub DOI_EXCEL_MACRO()
Dim lv_count As Long
Dim i As Integer
Set R3Table = ThisWorkbook.Container.LINKSERVER.ITEMS("GT_SFLIGHT").Table
Worksheets("1").Select
Set wordTbi = ThisWorkbook.Worksheets(1)
lv_count = R3Table.RowCount
For i = 1 To lv_count
wordTbi.Cells(i + 1, 1) = CVar(R3Table.Value(i, 1))
wordTbi.Cells(i + 1, 2) = CVar(R3Table.Value(i, 2))
Next i
End Sub
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
» | Sub DOI_EXCEL_MACRO() | sapjoy | 2008.12.26 | 3317 |
310 | Sub DOI_MACRO() | sapjoy | 2008.12.26 | 2848 |
309 |
DOI_002.doc
[3] ![]() | sapjoy | 2008.12.26 | 2236 |
308 | doi_create [1] | sapjoy | 2008.12.26 | 3054 |
307 | REPORT zsapdoi_001. [2] | sapjoy | 2008.12.20 | 3141 |
306 | REPORT Z07_026 [3] | sapjoy | 2006.12.09 | 2634 |
305 | Include ZXQEVU10 | sapjoy | 2008.12.17 | 2159 |
304 | Include ZXCSAU05 | sapjoy | 2008.12.17 | 2167 |
303 | FIELD_EXIT_STCD2_0 | sapjoy | 2008.12.16 | 2804 |
302 | FIELD_EXIT_GSBER_I | sapjoy | 2008.12.16 | 2626 |
301 | Include ZXCSAU05 | sapjoy | 2008.12.16 | 2588 |
300 | INCLUDE ZXF04U01 | sapjoy | 2008.12.16 | 3710 |
299 | INLUCDE ZXAISU02 | sapjoy | 2008.12.16 | 2963 |
298 | REPORT z_userexit_01 | sapjoy | 2008.12.15 | 2657 |
297 | REPORT ZSMARTFORMS_01. | sapjoy | 2008.11.26 | 2679 |
296 | report zunicode_035. | sapjoy | 2008.11.22 | 2543 |
295 | report zunicode_034. [1] | sapjoy | 2008.11.22 | 2740 |
294 | report zunicode_032. | sapjoy | 2008.11.22 | 2635 |
293 | report zunicode_031. | sapjoy | 2008.11.22 | 2687 |
292 | report zunicode_030. | sapjoy | 2008.11.22 | 2418 |