Prev: Error on opening Excel workbook
Next: 2007 - link named excel range to word document
From: Quintin11 on 8 Feb 2010 16:25
Greetings, all.
I am currently importing some text files into Excel, and wanted to find out
if it's possible to import mulitple files. I can't seem to select more than
one file from the list at this time.
The files are Text, and are all bascially the same. They are space
delimited, and I have no problems using the wizard to import single files.
Since I usually have 8-10 files to import, is there a way to import them as
a group? I sure hope so, my clicking finger is wearing out!
Thanks in advance!
Paul Q
From: Jim Thomlinson on 8 Feb 2010 17:31
The short answer is no. While you know that the file formats are the same XL
doesn't and as such it will not allow multiple file imports.

You could do a macro but it will require a bit of custom coding to allow you
to pick the files... do-able but not for the faint of heart.
--
HTH...

Jim Thomlinson


"Quintin11" wrote:

> Greetings, all.
> I am currently importing some text files into Excel, and wanted to find out
> if it's possible to import mulitple files. I can't seem to select more than
> one file from the list at this time.
> The files are Text, and are all bascially the same. They are space
> delimited, and I have no problems using the wizard to import single files.
> Since I usually have 8-10 files to import, is there a way to import them as
> a group? I sure hope so, my clicking finger is wearing out!
> Thanks in advance!
> Paul Q
 | 
Pages: 1
Prev: Error on opening Excel workbook
Next: 2007 - link named excel range to word document