cvs

Good Morning, I've got the code below -- I was hoping just adding CVS to the filter would allow me to import it but it doesn't so I need to help. How can I get this code to import CVS files? Sub ActiveRateCategory() Sheets("ActvRateCat SumRpt").Range("A:M").Clear Dim wkbCrntWorkBook As...

Hello I want to learn how to import/export cvs to excel. I am looking for a cvs file that I can use to do that. I tried to search the internet for a sample of these files but could not find any. Any idea where to find a sample of these CVS files? Thank you so much.

I dumped some CDR files from our phone system and I need to sort out the data in the CVS file. Doing it manually takes almost all day long to do it as we get countless calls. I found this code online which works great to delete all the columns I don't need. However, it's only doing part of what...

Hi all, Sorry after searching a few days i can't find a solution to my problem. I import in excel a cvs file, and I just want to add times ( elapsed times ) The format of the data is 00:00:00:00 as days:hours:mins:secs I understood that dd:hh:mm:ss is not a valid format for this ( day bein the...

Hi all, I have developed a rather large application with VBA that we use at work. The problem with this is that the database is now in the excel application, and that means that no more than one person can use the application at a time. This is normally ok, but I thought I would try to fix this...