View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Import .prn file to Excel

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

.