메뉴 건너뛰기

SAP 한국 커뮤니티

Sub DOI_EXCEL_MACRO()

sapjoy 2008.12.26 11:32 조회 수 : 3312

    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


 

번호 제목 글쓴이 날짜 조회 수
649 <b>ABAP SOURCE는 교재에 사용된 소스들입니다.</b> [1] sapjoy 2006.12.02 3618
648 REPORT z19_01. sapjoy 2012.08.01 3526
647 z_exception_test sapjoy 2010.10.10 3520
646 report zsalv_036 . sapjoy 2010.08.20 3472
645 REPORT ZSMARTFORMS_03. sapjoy 2008.11.28 3345
644 REPORT z18_04 . sapjoy 2012.08.01 3344
643 REPORT z18_05 sapjoy 2012.08.01 3328
» Sub DOI_EXCEL_MACRO() sapjoy 2008.12.26 3312
641 REPORT z18_003 sapjoy 2007.03.05 3281
640 subroutine pool sapjoy 2013.11.15 3273
639 REPORT z19_004 sapjoy 2007.03.27 3230
638 REPORT Z_WHEREUSEDLIST [4] sapjoy 2011.03.28 3215
637 REPORT ZALVCOLOR sapjoy 2010.10.09 3212
636 REPORT ZSAPTIP_002. sapjoy 2009.02.20 3206
635 zsalv_edit [1] sapjoy 2010.08.20 3205
634 REPORT Z06_001 MESSAGE-ID ZTEST . [1] sapjoy 2006.12.05 3205
633 REPORT z18_06. sapjoy 2012.08.01 3147
632 REPORT zsapdoi_001. [2] sapjoy 2008.12.20 3135
631 report zsalv_042 . sapjoy 2010.08.20 3132
630 REPORT z18_01. sapjoy 2012.08.01 3108