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?

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" <(E-Mail Removed)> wrote in message
news:5C819B35-EB8D-4341-91EB-(E-Mail Removed)...
>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?