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

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
>
>