Auto import of data into excel
 

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!

Auto import of data into excel
 

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

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

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200806/1

Auto import of data into excel
 

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

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