-
May 8th, 2012, 01:20 AM
#1
Thread Starter
New Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|