Importing a .csv file into excel

[nynamyna]

Hello everybody,

I know this is a common question. But, I tried doing it and I am not able to do it. I have a .csv file which I need to import into excel. I tried recording a macro but it is not dynamic. I need to do the following

1. When I run the macro it should let me to choose the .csv file

2. A new sheet should be created with the name of the csv file chosen and the data should be pasted in that sheet.

Please guide me so that I can do it.

Thanks,
Ram

 

[JPM]

You could try this simple macro which allows you to enter the file name:

Sub Macro2()


Name = InputBox("Please enter the name and path of the file to be imported: (i.e. c:\test.csv)", "Name", "xxxxx")
Workbooks.Open Filename:=Name
'Change "Book1" to your xls file name
ActiveSheet.Copy After:=Workbooks("Book1").Sheets(3)

End Sub

 

[nynamyna]

Thanks..That worked out