메뉴 건너뛰기

SAP 한국 커뮤니티

Sub DOI_EXCEL_MACRO()

sapjoy 2008.12.26 20: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


 

번호 제목 글쓴이 날짜 조회 수
» Sub DOI_EXCEL_MACRO() sapjoy 2008.12.26 3312
310 Sub DOI_MACRO() sapjoy 2008.12.26 2845
309 DOI_002.doc [3] file sapjoy 2008.12.26 2234
308 doi_create [1] sapjoy 2008.12.26 3049
307 REPORT zsapdoi_001. [2] sapjoy 2008.12.20 3137
306 REPORT Z07_026 [3] sapjoy 2006.12.09 2632
305 Include ZXQEVU10 sapjoy 2008.12.17 2158
304 Include ZXCSAU05 sapjoy 2008.12.17 2166
303 FIELD_EXIT_STCD2_0 sapjoy 2008.12.16 2797
302 FIELD_EXIT_GSBER_I sapjoy 2008.12.16 2625
301 Include ZXCSAU05 sapjoy 2008.12.16 2587
300 INCLUDE ZXF04U01 sapjoy 2008.12.16 3698
299 INLUCDE ZXAISU02 sapjoy 2008.12.16 2962
298 REPORT z_userexit_01 sapjoy 2008.12.15 2656
297 REPORT ZSMARTFORMS_01. sapjoy 2008.11.26 2677
296 report zunicode_035. sapjoy 2008.11.22 2541
295 report zunicode_034. [1] sapjoy 2008.11.22 2737
294 report zunicode_032. sapjoy 2008.11.22 2634
293 report zunicode_031. sapjoy 2008.11.22 2684
292 report zunicode_030. sapjoy 2008.11.22 2416