If you renamed an Excel file it would still be an Excel file, but Excel may not recognise it as such.
It would be far better to open the file and then go to the File... Save As menu, select the file type as either Text (Tab-delimited) or csv (Comma Separated Values) give it a filename and click Save. You would then be able to open it in any text editor. Note that you can only save one worksheet, so if you had several worksheets you would have to save each one as a separate file.
Rename the Excel file with ext name ".xls" then it is normally open........
well. u can open excel and file u should see the recent opened files if not try searching .xml with last modified ( when did u rename it ) then search that's all :)
You wouldn't rename a file in Excel. You would normally do it through Windows Explorer. However when opening a file in Excel, when the Open Dialog is open, it is possible to click on a file and rename it or do it through the Tools menu in the Open Dialog box. However you would rarely use that approach. The other thing you can do is use Save As and choose a new name, which will give you a copy and retain the old file.
Click on File then Save As and then change the title.
A DOS editor is not capable of reading a standard Excel file. An Excel file must be opened with Excel or some application that can read Excel files. Text editors are not capable of doing that. They are designed for working on things like text files.If you have a standard Excel file and save it as a text file, then text editors can open them. All that will be in that is pure text, and not things like formulas and calculations and formatting etc. When you are saving as a text file, save it with a txt extension and most text editors will be able to open it. How you specifically do it will depend on the particular text editor you are using.
My.Computer.FileSystem.RenameFile("C:\mydocs\oldfile.xls", "newfile.xls")
From editor: File / Save As or File / Write To From shell: rename, move, mv
The answer is: False
true
One way would be to copy the data into a text file, using Notepad perhaps, and then save the file and open it with Excel. The text will then be in different cells. You could then copy that data back into the original Excel file.
It means that you open an existing text file using an application like Notepad, Word, Excel etc.
text