메뉴 건너뛰기

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


 

번호 제목 글쓴이 날짜 조회 수
650 REPORT Z12_03 sapjoy 2012.07.30 818
649 REPORT z14_07. sapjoy 2012.08.01 818
648 REPORT z10_08. sapjoy 2012.07.30 819
647 REPORT Z05_34. sapjoy 2012.07.30 823
646 REPORT Z08_01. sapjoy 2012.07.30 824
645 REPORT z05_28. [1] sapjoy 2012.07.30 824
644 REPORT z08_02. sapjoy 2012.07.30 829
643 REPORT z10_01. sapjoy 2012.07.30 830
642 REPORT z14_11. sapjoy 2012.08.01 836
641 REPORT z10_03. sapjoy 2012.07.30 837
640 REPORT z11_07. sapjoy 2012.07.30 840
639 REPORT Z14_02. sapjoy 2012.08.01 843
638 REPORT z10_05. sapjoy 2012.07.30 845
637 REPORT z14_10. sapjoy 2012.08.01 848
636 REPORT z05_10. sapjoy 2012.07.30 849
635 REPORT z05_30. sapjoy 2012.07.30 850
634 REPORT z10_13. sapjoy 2012.07.30 850
633 REPORT z14_12. sapjoy 2012.08.01 852
632 REPORT Z05_33. sapjoy 2012.07.30 853
631 REPORT z14_05. sapjoy 2012.08.01 857