I am a newbie so please don't freak if you find this question stupid or easy
I have some data in CSV format, which I want to bring into Excel, and based on that data, I have to create graphs in PowerPoint.
I searched on Google and everywhere I find complex techniques to bring data into data-bases using some ADO objects and something called RECORDSET.
I want to know if there is something simpler which brings data into excel only.
Here is the Code till now.
sub importData() fileName = Application.GetOpenFilename("Text Files (*.csv),*.csv", , "Please selec text file (in .csv format)...") If fileName = "False" Then Exit Sub [I]'User pressed Cancel on the open file dialog[/I] End Sub
save data from this file (
fileName ) in excel
create graph in PowerPoint.
Please provide guidance