Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import .prn file to Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import .prn file to Excel
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import .prn file to Excel
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. -- Regards, Tom Ogilvy "Frank Kabel" wrote in 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import .prn file to Excel
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import .prn file to Excel
just do file = Open and select your file.
-- 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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import .prn file to Excel
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. -- Regards Frank Kabel Frankfurt, Germany wrote: 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 . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import .prn file to Excel
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) Tom Ogilvy wrote: 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. -- Regards, Tom Ogilvy "Frank Kabel" wrote in 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
Import more than one .csv file into the same Excel file. | Excel Discussion (Misc queries) | |||
import file so that it is a actual csv file, no excel cell version | New Users to Excel | |||
import data from txt file to an existing excel file | Excel Discussion (Misc queries) | |||
How come I can't import an .svc file(Open Office) to Excel file? | Excel Discussion (Misc queries) |