anuradhagrewal
Board Regular
- Joined
- Dec 3, 2020
- Messages
- 85
- Office Version
- 2010
- Platform
- Windows
Hello
I have an excel sheet in which I regularly need to import data that is in *.csv format.
I would be very grateful if someone can provide me a VB code where I can import in a query all these csv files into the existing Excel file.
I have been able to find code where the codes *.csv files are imported but with the csv file name.
I want that the file name, this I want to be replaced by a number like 1,2,3 etc depending on the number of csv files imported.
Can anyone please help me.
Much Obliged
Regards
Anu
I have an excel sheet in which I regularly need to import data that is in *.csv format.
I would be very grateful if someone can provide me a VB code where I can import in a query all these csv files into the existing Excel file.
I have been able to find code where the codes *.csv files are imported but with the csv file name.
I want that the file name, this I want to be replaced by a number like 1,2,3 etc depending on the number of csv files imported.
Can anyone please help me.
Much Obliged
Regards
Anu
