Results 1 to 1 of 1

Thread: vb code to upload xlsm file

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2012
    Posts
    2

    vb code to upload xlsm file

    vb code to upload xlsm file : i get err
    Private Sub updatOrdTab_Click()
    Dim HEADER,Deal,Deal1 As varchar2
    Con.Open
    Set xlwbook = xl.Workbooks.Open("D:\u\ddd.xlsm")
    Set xlsheet = xlwbook.sheet2
    Con.BeginTrans
    'stri = xlsheet.Cells( HEADER, 2)
    Do Until HEADER = 13
    deal = xlsheet.Cells( HEADER, 1)
    deal1= xlsheet.Cells( HEADER, 2)

    HEADER = HEADER + 1
    Loop
    Con.CommitTrans

    End Sub



    bt i get the external table is not in the expected format when i run this code
    Last edited by anjaliap; May 22nd, 2012 at 02:42 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width