'the code is working properly only problem with this code is when the first line ends in excel and data is inserted in next Row "instead of inserting another row it copies the same content which is inseted last time in form "
No that post is different than this one that is related to connecting to database.I have created a form in vb and then used excel to output my data .i mean i used excel at backend.
My problem is first row gets fine but when i try to put another row through form it overwrites the already written first row.
It looks like you're declaring
RowCount every time the routine is run, which will reset it's value. Try making it global.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.