I am a newbie here in the VBA world...could use a little help:
I'm trying to create a macro which imports data from a text file into a
specific worksheet on the workbook I have open...with specific delimited
perameters. I tried recording a macro but the only way that I know how to do
it is by simply opening the file which creates a whole new workbook. I
finally came up with something on my personal computer which creates a query,
and when I tried it on my computer at work it didn't work because the query
is not installed.
Is there a way to do this without creating a query?
Also I realized that when the document is opened in excel, it is still the
original file...I want to copy the data because there is a lot that needs to
be done with the information without disrupting the txt file. I've come so
close with a few different code's but now I'm stumped...