Auto import of data into excel

N

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!
 
N

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Utility to flatten/import X12 834 file into Excel 3
How To Import Excel Data With Excel 2007? 1
Import Text file Data into Excel Sheet 3
import data 2
Import file to excel 2
Excel Import External Data Wizard 3
Scroll when importing data 2
Access Subscript out of range when importing into access 2010 from excel 0

Top