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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
330 | REPORT zale_001 . | sapjoy | 2009.02.10 | 2470 |
329 | REPORT ZBAPI_002. | sapjoy | 2009.02.09 | 2590 |
328 | FUNCTION Z_BAPI_REQ_FUNCLOC. | sapjoy | 2009.02.05 | 2421 |
327 | REPORT ZBAPI_ALE | sapjoy | 2009.02.05 | 2334 |
326 | zbapi_java | sapjoy | 2009.02.02 | 2693 |
325 | FUNCTION Z_BAPI_ASSETNAME_SEARCH | sapjoy | 2009.01.30 | 2898 |
324 | REPORT ZSMARTFORMS_07. | sapjoy | 2009.01.22 | 2389 |
323 | REPORT zBADI_FIND | sapjoy | 2009.01.15 | 2724 |
322 | REPORT ZBADI_003. | sapjoy | 2009.01.14 | 2403 |
321 | REPORT zbadi_002. | sapjoy | 2009.01.09 | 2545 |
320 | REPORT zbadi_001 | sapjoy | 2009.01.06 | 2527 |
319 | doi_excel.xls | sapjoy | 2008.12.26 | 2177 |
318 | report zsapdoi_005. | sapjoy | 2008.12.26 | 2978 |
317 | report zsapdoi_004. | sapjoy | 2008.12.26 | 2923 |
316 | report zsapdoi_003. | sapjoy | 2008.12.26 | 2570 |
315 | report zsapdoi_002. | sapjoy | 2008.12.26 | 4405 |
» | Sub DOI_EXCEL_MACRO() | sapjoy | 2008.12.26 | 3312 |
313 | Sub DOI_MACRO() | sapjoy | 2008.12.26 | 2842 |
312 | DOI_002.doc [3] | sapjoy | 2008.12.26 | 2233 |
311 | doi_create [1] | sapjoy | 2008.12.25 | 3040 |