Hi experts, how to import csv files into ms Excel using visual basic.

[wedd]

Hi experts, how would you import csv files into ms Excel using visual basic or a macro. I would like to import csv files into excel 2007 on a click of a button on a spreadsheet, that automatically populates. Can this done. if so how? Would you have any examples of code, websites or personal experience of what steps or code or macro you did in handling this type of task?



Thanks for your contributions

[shrivallabha]

One would be to use macro recorder to record all the steps.

Also maybe you can try this link:
http://www.cpearson.com/excel/ImpText.aspx

[wedd]

Thanks shrivallabha!