View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nickodemos nickodemos is offline
external usenet poster
 
Posts: 2
Default Import file information

I am a moderator at a website and part of my job is to look for
people who have a bad upload ratio. Right now I am downloading this
information with a macro program and when I am done cleaning it up I
have this:

1spice,Members,04/12/2008 08:19:13,22/04/2009 11:44:51,Australia,0.94
77raptor,Members,11/11/2008 17:13:06,22/04/2009 14:38:52,Canada,2.12

And I also go a step further to find the low ratio's by making them
look this way:

(0.25)VAGMAVRO
(0.26)erekose

What I would like to do is to be able to import the information
directly from the first example with today's date as a column. So I
would like to do daily imports from a CVS file where it looks like
this:

Username Userlevel 22Apr2009 23Apr2009
3x2y1z Members 0.23 0.45
badmule Members 1.65 1.67

Is there a way to import daily files so that it goes to the persons
name but added to today's column? Right now I am working with text
files and it gets to be difficult to read as I add more days to a
single file with over 400 people.

nickodemos