Here's what I'm looking for in a nutshell:

I want Excel to look into a directory (ie. C:\data ), and when it
see's MyData.csv, it imports the data and then deletes the file.

I've got the import routine written. I just don't have the auto in
and out done.

Does anyone have a link to somewhere I can find out how do this? My
googling isn't what it is normally when I'm not doped up on meds, like
right now.

Thanks a bunch!

Thanks. I was on vacation, so that's why I couldn't get back to you
so soon.

I like that. I can impliement that. But how will excel know when the
file is there to be imported? How do I have it check the directory
for the file say, every 5 seconds or so?

On Jun 15, 5:41*am, "Crowbar via OfficeKB.com" <u15117@uwe> wrote:
> Hi There,
>
> So your program currently opens the .csv file and puts the data the way you
> want it?
>
> If so then all you need to do is delete your .csv file, is this correct?
>
> if yes just use this command and it will delete the file
>
> kill "C:\WhatEverYourFileIs.csv"
>
> Anything else contact me prec_...@yahoo.com
>
> http://www.apofficesolutions.co.uk
>
> Nondisclosure007 wrote:
> >Here's what I'm looking for in a nutshell:
>
> >I want Excel to look into a directory (ie. C:\data ), and when it
> >see's MyData.csv, it imports the data and then deletes the file.
>
> >I've got the import routine written. *I just don't have the auto in
> >and out done.
>
> >Does anyone have a link to somewhere I can find out how do this? *My
> >googling isn't what it is normally when I'm not doped up on meds, like
> >right now. * *
>
> >Thanks a bunch!
>
> --
> Anthony Prescotthttp://www.apofficesolutions.co.uk
>
> Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200806/1