Hello
I have a problem to be solved in excel vba. My requirement is , I have a folder with several text / doc files. I need a folder with excel files with same file names which are in the text folder and the data in the text files should be in the excel file. Simply importing data from text file and saving the file with the text file name from which the data is extracted. This should be done to all the text files that are available in the folder( usually I will have 100 text file in the folder. Thank you in advance for your help Plz call me/text me/ mail me/WhatsApp me at any time regarding this. I will be waiting for your reply Thanking you Prasad +91 9291313607 tradersbasket@gmail.com To explain my query breafly I came up with the live example. I have 100 text files in folder A. I need 100 excel files in folder B with same file names as in the folder A. Each excel file should have the data extracted from the same text file name. Or to say it in technical way. Find the first text file in folder A , import that data and save the excel file with the same file name but with excel file extension. Loop this until / for all the files in folder A. Hope I explained well enough. If not let me know/ call me/ WhatsApp me/ text me/ email me. Thanking you in advance.
name: Prasad.
WhatsApp +91 9291313607
Email:tradersbasket@gmail.com