Hi everyone!!!
I am trying to fetch data from an excel sheet to an other sheet or to ole automation in vb. the main problem is that i have to search data on the basis of two date intervals and nd then copy data from related cells recorded in that date period!!
Please suggest me suitable programming regarding this program!!!
thanx in advance
try ur best!!!

You can do this via com or automation, or you can use ado... use friends (yahoo, google, ask, answers, bing) to search for vb6 automating excel tutorial or vb6 ado excel...

Good Luck

hi
thanx vb5prgrmr for the response
i'm quit new to vb 6.0 just above basic level.
i've just started automating excel so i m finding very hard to automate and specially to read excel sheet from vb and search contents with in it.
cdn't u please give me some programming hints!!
otherwise thanx for trying nd replin me!!!
waiting for your reply!!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.