I am not sure what you mean. I have use macros all the time, but what is a
VBA macro? There are six different text files that get imported daily into a
it's own separate spreadsheet, and all are named with the date and which
cycle it is. Does a vba macro take that into consideration?

"future_vba_expert" wrote:

If you were using a vba macro, you could automate the whole import. Have you
considered that?
--
future_vba_expert


"balterson" wrote:

When I import a text file and use set widths, there are already preset line
breaks there. Is there a way to set the default location for these lines? I
import text files every day, and have to move the breaks that are there. It
would be much faster to have these preset where I want them. Any hlep would
be great.