Search results for query: *

Hi, I am handling a strange file with many strange characters that I am not the originator of. Objective is to modify some lines of the file without destroying the other ones. Importing into a worksheet does modifications; whereas editing in notepad is OK. Strange enough the line-by-line copy...

Hi JazzyLee, I saved line by line into a file, and used a book to find how to do it. In principle you create a file, then you loop throuth the cells of a line to create one string per line, and then you write this line-string into the file and so forth: ' Microsoft Scripting Runtime must be...

Hi PHV, Thanks for your reply; The xlTextWindows-switch you propose produces the same quotation marks in my environment; However, your response has let me think that text is no excel format, and now I export the spreadsheet using a FileSystemObject writing line by line into a text file...

Hi, I want to save a worksheet of a workbook as a text-document. My newbie problem is that the VBA macro adds quote marks "" around the contents of some cells; whereas the manual File-Save As ... does not. I found a work-around by delimiting the length of the string in that cell, which was a...

Seeing this thread, I wonder whether somebody also has the formula for the great-circle distance in nautical miles between aircraft flying at different altitudes?