I've got a csv file with comma delimiters, and would like to retrieve the data within a chosen date range. The date format at the beggining of each row is mm/dd/yyyy and the inputs are the initial date and end date so as the search ignores those rows out of the chosen range.
Is it possible to do that?
Last edited by dvb_24; 11-23-2011 at 06:10 AM. Reason: clarify
I have this but don't know how to match the dates
Do While Not a.AtEndOfStream
strLine = a.ReadLine
Loop
Can you please attach the CSV file and also provide the date range you are looking at with its respective fields in the file.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks for your help. I would like to get from 1st of june 2010 to 1 of sep 2011.
I'm having troubles to upload the csv file so have upload a txt instead which has a different delimiter but think that might be very similar.
Last edited by dvb_24; 11-22-2011 at 05:09 AM.
Is this date range constant? Or do you want the user to input the date range?
The range is not constant so would like it to be flexible.
Use this code -
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks