PDA

View Full Version : Hi experts, how to import csv files into ms Excel using visual basic.



wedd
02-14-2012, 10:05 AM
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:friends:

shrivallabha
02-14-2012, 10:14 AM
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
02-14-2012, 11:07 AM
Thanks shrivallabha!