automated import of csv files into excel

  • Thread starter Thread starter weka
  • Start date Start date
W

weka

I need to code an automated process when a csv type files is
automatically imported into excel, which in turn will be presented on a
web page using asp. How do I automaticlly import the csv file ?
 
weka

You can open CSV files natively in Excel. Just use

Workbooks.Open("C:\MyFile.csv")
 
You must log in or register to reply here.

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

Automate Excel export to a CSV file 1
Which is the best MBOX Converter Tool different formats conversion? 4
Get Standard CSV File 2
Forcing Excel to Import .CSV data 2
Access Importing csv daily files into access 2007 1
Macro to import CSV file from fixed directory 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
CSV-file as semicolon se 2

Back
Top