Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi List,
User has 4 CSV format files. Since there are extra spaces in the files when open them from Excel, they have to open each of them using NotePad and delete the extra spaces. They can't do this from CSV file directly. If they deleted the extra empty column from Excel, and open it again with NotePad, the " " will disappear. They want these steps can be handle using a macro, so they don't need to manually open each file and delete the spaces. What I did: I open csv file as input, use trim(string) to get rid of the extra spaces. then i write each row to a .txt file. if i open the txt file using NotePad then do SaveAs to a csv file. it works fine. when user reviewing it from NotePad, they still see " " around each field. But my question is, how can I accomplish this step using VBA? I tried to open the txt file from Excel and save it as .csv file, when i open the .csv file from NotePad, all the quotes were gone. I have posted my questions for a couple of days, but didn't get any answers so far. Please, if anyone has any idea, please let me know. Thanks so much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions | |||
Excel marcos firing on file save as but not file save | Excel Programming | |||
Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
Save As - Multiple Sheets fails to save as text file | Excel Programming |