Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Update Delimited/Comma Seperated File .
Hi,
I have an exported file saved which has all it's values in Column A, with each value seperated by ". If I open the file manually, I can go through the steps to seperated the values, which is fine. However, I have a sub which is going to open my delimited file overnight, so I would like to automatically amend the file, seperating the values. I have Application.Dialogs(xlDialogTextToColumns).Show, but it requires user input, which is a no-no. Cheers Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Update Delimited/Comma Seperated File .
Hi tony,
before you open it - you may go Tools-Macros-Record New Macro then open the file and through the steps to seperated the values... then see the code in the Visual Basic Editor... HTH João Rodrigues "bony_tony" wrote: Hi, I have an exported file saved which has all it's values in Column A, with each value seperated by ". If I open the file manually, I can go through the steps to seperated the values, which is fine. However, I have a sub which is going to open my delimited file overnight, so I would like to automatically amend the file, seperating the values. I have Application.Dialogs(xlDialogTextToColumns).Show, but it requires user input, which is a no-no. Cheers Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Update Delimited/Comma Seperated File Options | Excel Programming | |||
Automatically Update Delimited/Comma Seperated File | Excel Programming | |||
Comma Seperated File | Excel Worksheet Functions | |||
comma seperated file import | Excel Discussion (Misc queries) | |||
Problems converted comma seperated CVS file! | Excel Programming |