View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
markythesk8erboi markythesk8erboi is offline
external usenet poster
 
Posts: 28
Default 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?