Thread: Can it be done
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Can it be done

Grace
If you can define boundaries then VBA can set them.
Cheers
Nigel

"Grace" wrote in message
...
In my EXCEL template, I have to import a lot of text files that come in as
CSVs. Setting the boundaries turns out to be very time-consuming.
Assuming, for the sake of argument, that I could find some rules as to

where
to set boundaries, is there any way that a macro could be written to have

it
delete all preset boundaries and then insert boundaries between the

columns
based on these rules?

Thanks!
Grace