How can I set up an excel file to auto import data from a CSV fil
 

I have a program that sends information into a .csv file. Unfortunately I can
not use formatting options with this file (ex. formatting cells as currancy)
So, I want to create an excel file that will automatically update every 1
minute or so.
The only problem I'm having is that everytime it goes to import excel asks
me what file I want to import from. Is there anyway to set it up so that it
goes to the same file every minute and simply updates the excel file without
excel having to verify the file its pulling information on?

How can I set up an excel file to auto import data from a CSV fil
 

Is the data appended to the existing file, or is the entire file overwritten?

You can certainly use the Application.OnTime method to schedule a macro to run once every minute -
you will just need code to figure out which data to pull (if the data is appended).

HTH,
Bernie
MS Excel MVP


"markythesk8erboi" wrote in message
...
I have a program that sends information into a .csv file. Unfortunately I can
not use formatting options with this file (ex. formatting cells as currancy)
So, I want to create an excel file that will automatically update every 1
minute or so.
The only problem I'm having is that everytime it goes to import excel asks
me what file I want to import from. Is there anyway to set it up so that it
goes to the same file every minute and simply updates the excel file without
excel having to verify the file its pulling information on?