Auto import of data into excel

[Nondisclosure007]

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!

 

[Crowbar via OfficeKB.com]

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 (e-mail address removed)

http://www.apofficesolutions.co.uk

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 Prescott
http://www.apofficesolutions.co.uk

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-programming/200806/1

 

[Nondisclosure007]

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?