Thanks

I have a big text file (standalone). I want to analyze the data in it. In order to analyze it, I need MS Excel. I wrote a macro that reads the data from the text file into array, analyze the data and at the end import the text file as an OLE Object (from Menu bar I Choose Insert, then Object and then the file name). I can't paste the text file to sheet, since the number of lines is text file is bigger than the max number of lines in Excel sheet. Then I save the Excel file. I have a sheet that contains an object in it. I send this Excel file. Now, I assume that I get the Excel file. I open the saved file. I want to analyze only part part of the data. I need to read the text file into the array. The text file is located in the sheet, and I don'd know how to read data from it. If I will copy this text file outside of the Excel, I will know how to read it. I need the code to copy this textfile outside of the excel. (I succedded to copy the text file to the clipboard, but not from the clipboard to the desired directory. Thanks

I checked this option, but it seems that I can't use SaveAs function for OLEObject. Can you write me the code lines of how to save OLEObject (that contains one item - which is text file) to text file? Thanks

While using Excel, I imported text file as an object (imported as OLEObject). I want to export it back to a text file. I can copy it to the clipboard, but I don't know how to copy it from the clipboard to a path.

Using Excel, I inserted a text file to the sheet, and pasted it as an OLEObject (from the Excel menu "insert" then "object" and choose text file). I want to read the file context (using Excel VB macro), but I don't know how to access and open this OLEObject (whitch contains the file).