메뉴 건너뛰기

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


 

번호 제목 글쓴이 날짜 조회 수
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 file 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] file sapjoy 2008.12.26 2233
311 doi_create [1] sapjoy 2008.12.25 3040