Hi All I need to import csv file

[menon2000]

Hi All

I need to import csv file on a specific folder to a excel worksheet. This process has to be auto (i.e If the csv file is changed and the excel is opened the latest data of the csv file should be seen on the excel work sheet)

Looking forward for the help.

thanks
Menon

 

[xlbo]

Have a look at the Data>Get External data options

You can choose text files as a query base and you can set it to refresh when you open the file......

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244