Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help writing output to a file without <cr<lf carriage contr
(and how antiquated is the term "carriage")
I'm trying to automate the creation of a shell script that will be run under linux from excel VBA. The "dos" style of carriage control screws up proper interpretation of the file on the linux system. It is easy enough to fix the file before running it with sed or vim but I would like to be able to create it correctly in the first place. I tried opening the file as binary but and print strings like this: print #fid "string" & chr(10) I end up with a empty file! If I open the file up as output I do create a file but I get the <rc<lf problem. I'm sure this is simple and I'm missing something that will appear obvious in hindsight, but right now I am stuck. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help writing output to a file without <cr<lf carriage contr
Don wrote:
(and how antiquated is the term "carriage") I'm trying to automate the creation of a shell script that will be run under linux from excel VBA. The "dos" style of carriage control screws up proper interpretation of the file on the linux system. It is easy enough to fix the file before running it with sed or vim but I would like to be able to create it correctly in the first place. I tried opening the file as binary but and print strings like this: print #fid "string" & chr(10) I end up with a empty file! If I open the file up as output I do create a file but I get the <rc<lf problem. I'm sure this is simple and I'm missing something that will appear obvious in hindsight, but right now I am stuck. Any help would be appreciated. You want Print #fid "string; chr$(10); the ending ";" elimiates the crlf ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help writing output to a file without <cr<lf carriage c
That is obcure! Thanks. I actually found a different approach that works
using filesystemobect and textstream (documented here http://book.itzero.com/read/others/C...l/LiB0041.html) "Dave D-C" wrote: Don wrote: (and how antiquated is the term "carriage") I'm trying to automate the creation of a shell script that will be run under linux from excel VBA. The "dos" style of carriage control screws up proper interpretation of the file on the linux system. It is easy enough to fix the file before running it with sed or vim but I would like to be able to create it correctly in the first place. I tried opening the file as binary but and print strings like this: print #fid "string" & chr(10) I end up with a empty file! If I open the file up as output I do create a file but I get the <rc<lf problem. I'm sure this is simple and I'm missing something that will appear obvious in hindsight, but right now I am stuck. Any help would be appreciated. You want Print #fid "string; chr$(10); the ending ";" elimiates the crlf ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing output to a textbox while VBA macro is running | Excel Programming | |||
Tough One - Return output from Dos Process without writing to file | Excel Programming | |||
Carriage Return from HTML file | Excel Programming | |||
Can I control linked cell property value in a copied ActiveX contr | Excel Discussion (Misc queries) | |||
Writing an Excel Spreadsheet via a program's output | Excel Programming |