Due to this we could neither work on that file nor saving the file into excel format.

What is a text file in excel. To create a new module right-click your workbooks name in the editors project window and choose Insert Module. The two images below explain what the macro will actually do. I used File Explorer to navigate to its directory and then copied the path text from the Address bar Enter the other information shown.

However we can export a worksheet of existing workbook as text files with the Save As feature. The Text Import Wizard will open to the first of three steps. Embed text file in Excel.

Select the cell that you want the contents of the file to appear in. Convert text file to sheet with delimiter by Open. We all come across with such kind of situation where we had to put huge data in excel files but eventually we have faced the situation when the size of that file with the huge data went so up that we had to convert that into a text file.

One more method to insert a file into excel please follow the below steps Step 1. It seems like it would be straight forward routine to write though it has probably been written. Please do as follows.

Select Excel Cell into which you want to insert a file Step 2. Select Create from File. Click File Open Browse.

Opening a Text File in Excel. This kind of situation we have seen in. This is not as hard as we might want to believe.