Search results

I really apologize, if i hurt someone there in the forum.

Still Waiting for reply. :rolleyes::rolleyes:

Hello Narayank991, Here is the input data, voucherid voucherno transdate account debit credit I 0000000025 26-04-2013 ABCD ENTERPRIZES 0.00 50,000.00 I 0000000025 26-04-2013 ABCD BANK 50,000.00 0.00 I CAS0000002 23-05-2013 SIMPLE ENGINEERING SOLUTIONS 0.00 1,519.00 I CAS0000002 23-05-2013 CASH...

Hello Narayank991, First thank to reply me back soon. I want to generate XML With help of VB 6.0, I have below sample code snippet which gets single row data: Dim XMLPath As String XMLPath = "\Payment.Xml" Path = App.Path & "\" CommonDialog1.Filter = "Excel Files...

Hello, I have a following sample excelsheet data: voucherid voucherno transdate account debit credit I 0000000025 26-04-2013 ABCD ENTERPRIZES 0.00 50,000.00 I 0000000025 26-04-2013 ABCD BANK 50,000.00 0.00 I CAS0000002 23-05-2013 SIMPLE ENGINEERING SOLUTIONS 0.00 1,519.00 I CAS0000002...

Thats connstring work for me on XL 2007. Thank you much guys.

Hi again, Below is the excel sample data which i am using: UTRNO/CC No -------------- VYSAH13133605078 VYSAH13133605079 VYSAH13133605080 262820 262821 And i am getting error on cell value containing "262820" in vb as "Invalid use of Null" on VoucherNumberPay =...

Hi, Please help me i am getting error on using below Vb code from excel: Dim recPayment As New Recordset '************ Fields declar for read excel file '************* Connection to the excel file ************* connString = "DRIVER=Microsoft Excel Driver (*.xls);" &...