| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell to file
If I print a value of a cell to a file, there will be quotes in the file.
How to get rid of the quotes? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell to file
write some value or value of a variable to a file
"NickHK" schreef in bericht ... luc, Depends on how you are "printing a value of a cell to a file" ?? NickHK "luc" wrote in message ... If I print a value of a cell to a file, there will be quotes in the file. How to get rid of the quotes? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell to file
luc,
Depends on how you are "printing a value of a cell to a file" ?? NickHK "luc" wrote in message ... If I print a value of a cell to a file, there will be quotes in the file. How to get rid of the quotes? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell to file
luc,
Using what code ? NickHK "luc" wrote in message ... write some value or value of a variable to a file "NickHK" schreef in bericht ... luc, Depends on how you are "printing a value of a cell to a file" ?? NickHK "luc" wrote in message ... If I print a value of a cell to a file, there will be quotes in the file. How to get rid of the quotes? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell to file
Write #1, "UR :" & output_str1
"NickHK" schreef in bericht ... luc, Using what code ? NickHK "luc" wrote in message ... write some value or value of a variable to a file "NickHK" schreef in bericht ... luc, Depends on how you are "printing a value of a cell to a file" ?? NickHK "luc" wrote in message ... If I print a value of a cell to a file, there will be quotes in the file. How to get rid of the quotes? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell to file
If you look at the documentation for WRITE, you'll see it *always* adds quotes
around text. If you read it carefully, you'll also see a reference to the PRINT # function, and PRINT # is also listed when you click the "See also" link. That is the command you need; but if you are writing more than one item on a line, you'll have to add the delimiters between items yourself, in your code. On Tue, 16 Nov 2004 12:51:33 GMT, "luc" wrote: Write #1, "UR :" & output_str1 "NickHK" schreef in bericht ... luc, Using what code ? NickHK "luc" wrote in message ... write some value or value of a variable to a file "NickHK" schreef in bericht ... luc, Depends on how you are "printing a value of a cell to a file" ?? NickHK "luc" wrote in message ... If I print a value of a cell to a file, there will be quotes in the file. How to get rid of the quotes? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell to file
Use Print # instead of Write #. See VBA help for details.
-- Regards, Tom Ogilvy "luc" wrote in message ... Write #1, "UR :" & output_str1 "NickHK" schreef in bericht ... luc, Using what code ? NickHK "luc" wrote in message ... write some value or value of a variable to a file "NickHK" schreef in bericht ... luc, Depends on how you are "printing a value of a cell to a file" ?? NickHK "luc" wrote in message ... If I print a value of a cell to a file, there will be quotes in the file. How to get rid of the quotes? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import file so that it is a actual csv file, no excel cell version | New Users to Excel | |||
| Linking to another file using file reference typed cell | Excel Worksheet Functions | |||
| Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
| when inserting a file name in a cell how do you remove file type | Excel Worksheet Functions | |||
| Saving a file(new) using the multiple cell contents as a file name | Excel Programming | |||
Linear Mode
