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

Automatically Update Delimited/Comma Seperated File
 

Try using Data - Import External Data - External Data.

You can use Tools -Macro - Learn new macro while importing the data. Use
the code from the Learn New Macro to create your own macro.

"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