Import .prn file to Excel

  • Thread starter Thread starter meme
  • Start date Start date
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
 
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.
 
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.
 
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
 
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)
 
Back
Top