Import .prn file to Excel

M

meme

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
 
T

Tom Ogilvy

Just to add, if, as Dave Peterson pointed out in another post, if the .prn
file is generated with the generic Text print driver, then the prn file is
all text (or if it is otherwise all printable text) then you should be able
to open it in excel and get meaningful information. In that case, just use
the file open dialog and open it using the text import wizard.
 
F

Frank Kabel

Hi
just open the csv file. Excel will normally do the conversion. And also
have a look at Tom's post. Depending on the format of your *prn file
you may be able to open it.
 
T

Tom Ogilvy

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.count,1).End(xlup)

so you can open each file, then do

set rng = ThisWorkbook.Worksheets("AllData").Cells(rows.count,1).End(xlup)
Activeworkbook.Worksheets(1).Range("A1").CurrentRegion.Copy _
rng.Offset(1,0)
ActiveWorkbook.Close SaveChanges:=False
 
D

Dave Peterson

And another way to get those printable text files with a .prn extension is just:
file|save As|save as type
Formatted Text (Space delimited)(*.prn)
 
Top