I believe all macros in Excel are written in VBA (Visual Basic for
Applications). As Joel said in his reply, you can record what you are doing
manually, then next time you don't have to go thru all the steps; you can
just run the macro.
--
future_vba_expert


"balterson" wrote:

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.