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

M

markythesk8erboi

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?
 
B

Bernie Deitrick

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
 

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

Adding data to MS Access from csv file 0
Excel VBA macro to auto import new CSV file from fixed directory 1
Forcing Excel to Import .CSV data 2
Import Multiple CSV Files from Same Folder into Open Workbook 5
Macro to import CSV file from fixed directory 1
CSV-file as semicolon se 2
Problem creating a set of .csv files from coinciding worksheets 5
import multiple CSV files into one Excel file 3

Top