macro to import .csv to new sheet and rename it

hello friends

can someone help me?

i want to create a command button on excel to import .csv file in new sheet with predefined name.

Thanks in advance...

Originally Posted by patel45

attach a csv file please

Thanks for quick response.

this is the .csv file like this there are many other file so i want to create a command button on sheet1 when clicked it will ask the .csv file and after selecting it will import it in new sheet and with predefined name

Originally Posted by patel45

Please Login or Register  to view this content.

Thanks for the solution friends, now what happens is when i import file, the import sheet becomes active sheet
means in sheet1 i have created a button and assigned this macro to import csv file, and when i click this button it imports file but the imported sheet becomes active sheet so again i have to go to sheet1 where i have created command button to import next .csv file, so is it possible that this macro import file but sheet one will always be active sheet so that i can click command button to import next .csv file

Thanks for your response...

Thanks friends,

Now i have searched it and thanks for solving my query hope you will help me in my next post, now i am marking this threat as solve as you have solved this

Thank you very much for your help