Go automate it, turn on the macro recorder while you do it manually. Then
modify the basic code to get the result you want. To find the location
(bottom) of the last file brought in and placed in the consolidation
worksheet
set rng = ThisWorkbook.Worksheets("AllData").Cells(rows.coun t,1).End(xlup)
so you can open each file, then do
set rng = ThisWorkbook.Worksheets("AllData").Cells(rows.coun t,1).End(xlup)
Activeworkbook.Worksheets(1).Range("A1").CurrentRe gion.Copy _
rng.Offset(1,0)
ActiveWorkbook.Close SaveChanges:=False
--
Regards,
Tom Ogilvy
wrote in message
...
Then how about import .csv text file to Excel ?
Thank you
Meme
-----Original Message-----
Hi
AFAIK you won't be able to import 'prn' files into Excel
--
Regards
Frank Kabel
Frankfurt, Germany
meme wrote:
Hi,
I need import several .prn files to my Excel worksheet.
How should I program it in my VB code so all these .prn
files can be imported automatically ?
Any hints is very appreciate!!!!
Thank you very much
Meme
.