M
Martin
I want to import text files in to one worksheet. The text files are sent
daily and all the same format. However the text file names change buy an
incremental number.
Is it possible to create a macro that imports these text files,
ignoring their exact filename but from the same source directory into
one worksheet. Can you use wild cards for the name e.g. "********.txt"?
At the moment I can manually do this, by selecting the cell below the
last record then using the process "Get external Data" and following
the wizard which works fine.
As soon as I try to create a macro to automate the above simple
procedure, the import of the text file is inserted at the next empty
column rather than the next empty row.
Can this be resolved
Thanks in advanced
Martin
daily and all the same format. However the text file names change buy an
incremental number.
Is it possible to create a macro that imports these text files,
ignoring their exact filename but from the same source directory into
one worksheet. Can you use wild cards for the name e.g. "********.txt"?
At the moment I can manually do this, by selecting the cell below the
last record then using the process "Get external Data" and following
the wizard which works fine.
As soon as I try to create a macro to automate the above simple
procedure, the import of the text file is inserted at the next empty
column rather than the next empty row.
Can this be resolved
Thanks in advanced
Martin