Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have problems saving my text file in the right format? I am working on a macro that opens a text file, changes a value to a value found in another workbook, and saving the changed textfile with a new name. The lines in the text files contains both text and numbers, and are seperated by commas. The text file is opened with no delimiters and some of the lines are changed. The changing and renaming part works fine, but excel adds a " at each end of every line in the new text file when the macro saves the file. This doesn't happen when I save the file manually... Does anyone know how to avoid getting the " when the macro saves the file? Greetings Alex |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SQL-Query from a textfile? | Excel Programming | |||
Reading Textfile into a variable | Excel Programming | |||
Textfile-problem | Excel Programming | |||
Opening and saving textfile into XLS | Excel Programming | |||
Excel VBA to access URL as Textfile | Excel Programming |