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

Forcing Excel to Import .CSV data 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Save Excel file to a CSV without opening it first 4
Automate Excel export to a CSV file 1
Load a CSV into an empty, formatted XLS? 15
import csv data in excel using vb 1
Reading data from CSV file 2
Macro to import CSV file from fixed directory 1

Top