Page 1 of 1

How is it possible to import trt file ?

Posted: Tue Jun 03, 2014 11:21 am
by pLil
Dear Everybody,

How is it possible to import trt file in OpenOffice ?
Or where can someone convert lots of trt files to txt?
Please, help. It's urgent!

Thanks!
Lili

P.S. I'd like to use about 30 trt file in one worksheet (but in an old excel I have to import trt files singly).
And there are a lot of worksheet!

Re: How it is possible to import trt file ?

Posted: Tue Jun 03, 2014 11:30 am
by RoryOF
Not supported by anything but its originating program, as far as I can ascertain.

Re: How it is possible to import trt file ?

Posted: Tue Jun 03, 2014 11:38 am
by pLil
Thanks.
If I open trt file, sight is the same as it would be txt.

Re: How is it possible to import trt file ?

Posted: Tue Jun 03, 2014 12:54 pm
by pLil
Can someone write or copy a VBA code to import more trt file into one worksheet in excel?
If yes, could you write how make it step by step (e.g. Visual basic use, save macro, use macro, etc.)?

Re: How is it possible to import trt file ?

Posted: Tue Jun 03, 2014 1:07 pm
by Villeroy
pLil wrote:Thanks.
If I open trt file, sight is the same as it would be txt.
Well, then it might be text.
pLil wrote:Can someone write or copy a VBA code to import more trt file into one worksheet in excel?
If yes, could you write how make it step by step (e.g. Visual basic use, save macro, use macro, etc.)?
This is technically impossible without any data at hand. So far we only know that your files have a strange name suffix (trt).
Apart from that, we are not everybodies coding fools.

Re: How is it possible to import trt file ?

Posted: Tue Jun 03, 2014 1:43 pm
by pLil
It is clear. I could send you a trt file to see.
It's not fun, it's a real problem. I've to evaluate SMF datas, calibration, etc. for friday but on thursday I'll take another exam so I'd like to speed the data evaluation.
If you can't believe I can send you some page from the projectwork.

Re: How is it possible to import trt file ?

Posted: Tue Jun 03, 2014 1:47 pm
by pLil
There is a code e.g. but it doesn't work.
So if someone can modify it, it is simplier (in Excel).
---------------------------------------------------------------------

Code: Select all

Sub ImportDataFromTxtFiles()

Application.ScreenUpdating = False

Dim oFileDialog As FileDialog
Dim LoopFolderPath As String
Dim oFileSystem As FileSystemObject
Dim oLoopFolder As Folder
Dim oFilePath As File
Dim oFile As TextStream
Dim RowN As Long
Dim ColN As Long

On Error GoTo ERROR_HANDLER

Set oFileDialog = Application.FileDialog(msoFileDialogFolderPicker)

RowN = 1
With oFileDialog

With oFileDialog
If .Show Then
ActiveSheet.Columns(ColN).Cells.Clear

LoopFolderPath = .SelectedItems(1) & "\"

Set oFileSystem = CreateObject("Scripting.FileSystemObject")
Set oLoopFolder = oFileSystem.GetFolder(LoopFolderPath)

For Each oFilePath In oLoopFolder.Files
Set oFile = oFileSystem.OpenTextFile(oFilePath)

With oFile
Do Until .AtEndOfStream
ActiveSheet.Cells(RowN, ColN).Value = .ReadLine
RowN = RowN + 1
Loop

.Close
End With
Next oFilePath
End If
With oFileDialog
If .Show Then
ActiveSheet.Cells.Clear

LoopFolderPath = .SelectedItems(1) & "\"

Set oFileSystem = CreateObject("Scripting.FileSystemObject")
Set oLoopFolder = oFileSystem.GetFolder(LoopFolderPath)

For Each oFilePath In oLoopFolder.Files
Set oFile = oFileSystem.OpenTextFile(oFilePath)

With oFile
ColN = 3 ' To start from column C
Do Until .AtEndOfStream
ActiveSheet.Cells(RowN, ColN).Value = .ReadLine
ColN = ColN + 1
Loop

RowN = RowN + 1

.Close
End With
Next oFilePath
End If
End With
EXIT_SUB:
Set oFilePath = Nothing
Set oLoopFolder = Nothing
Set oFileSystem = Nothing
Set oFileDialog = Nothing

Application.ScreenUpdating = True

Exit Sub

ERROR_HANDLER:
' Some code for error handling
Err.Clear
GoTo EXIT_SUB


 
End Sub

Re: How is it possible to import trt file ?

Posted: Tue Jun 03, 2014 2:19 pm
by jrkrideau
Just send us a sample file if the data is not confidential. The code is probably meaningless if we don't have any data to examine.

You can attach a file when replying by going to the bottom of the window and following the attach file instructions. If the file is too big for upload to the forum you can post it at someplace such as MediaFire or Dropbox

Re: How is it possible to import trt file ?

Posted: Tue Jun 03, 2014 2:24 pm
by RoryOF
It will be easier and quicker to get access to a file running the correct software and Excel (if Excel understands this format). Even if the files must be loaded singly into Excel, to load 30 files can be done in a matter of a few minutes - certainly much quicker than writing or converting a macro and dealing with the subtleties of running/debugging such a macro on OpenOffice.

Re: How is it possible to import trt file ?

Posted: Fri Jul 25, 2014 1:37 pm
by Mark Nelson
SOLVUSOFT

What is File Extension TRT?
by: Jay Geater, Chief Technology Writer

Did someone email you a TRT file and you're not sure how to open it? Maybe you have found a TRT file on your computer and wondering what it's for? Windows might tell you that you can't open it, or in the worst case, you might encounter a TRT file related error message.

Before you can open a TRT file, you'll need to figure out what kind of file the TRT file extension refers to.

Tip: Incorrect TRT file association errors can be a symptom of other underlying issues within your Windows operating system. These invalid entries can also produce associated symptoms such as slow Windows startups, computer freezes, and other PC performance issues. Therefore, it highly recommended that you scan your Windows registry for invalid file associations and other issues related to a fragmented registry.

Answer:
TRT files are Uncommon Files primarily associated with Team Sports Scheduling System Report Template (Galactix Software).