How is it possible to import trt file ?

Not sure where to post? Post here!

How is it possible to import trt file ?

Postby pLil » Tue Jun 03, 2014 11:21 am

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!
Last edited by pLil on Tue Jun 03, 2014 11:42 am, edited 1 time in total.
OpenOffice 4.0.0
pLil
 
Posts: 5
Joined: Tue Jun 03, 2014 11:13 am

Re: How it is possible to import trt file ?

Postby RoryOF » Tue Jun 03, 2014 11:30 am

Not supported by anything but its originating program, as far as I can ascertain.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29440
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How it is possible to import trt file ?

Postby pLil » Tue Jun 03, 2014 11:38 am

Thanks.
If I open trt file, sight is the same as it would be txt.
OpenOffice 4.0.0
pLil
 
Posts: 5
Joined: Tue Jun 03, 2014 11:13 am

Re: How is it possible to import trt file ?

Postby pLil » Tue Jun 03, 2014 12:54 pm

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.)?
OpenOffice 4.0.0
pLil
 
Posts: 5
Joined: Tue Jun 03, 2014 11:13 am

Re: How is it possible to import trt file ?

Postby Villeroy » Tue Jun 03, 2014 1:07 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27101
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How is it possible to import trt file ?

Postby pLil » Tue Jun 03, 2014 1:43 pm

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.
OpenOffice 4.0.0
pLil
 
Posts: 5
Joined: Tue Jun 03, 2014 11:13 am

Re: How is it possible to import trt file ?

Postby pLil » Tue Jun 03, 2014 1:47 pm

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   Expand viewCollapse view
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
Last edited by RoryOF on Tue Jun 03, 2014 2:20 pm, edited 1 time in total.
Reason: Added [code] tags [RoryOF, Moderator]
OpenOffice 4.0.0
pLil
 
Posts: 5
Joined: Tue Jun 03, 2014 11:13 am

Re: How is it possible to import trt file ?

Postby jrkrideau » Tue Jun 03, 2014 2:19 pm

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
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3690
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: How is it possible to import trt file ?

Postby RoryOF » Tue Jun 03, 2014 2:24 pm

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.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29440
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How is it possible to import trt file ?

Postby Mark Nelson » Fri Jul 25, 2014 1:37 pm

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).
Windows 10
OpenOffice.org 4.1.1 LibreOffice 5.01
Mark Nelson
 
Posts: 107
Joined: Sat Nov 24, 2007 5:26 pm


Return to Beginners

Who is online

Users browsing this forum: No registered users and 7 guests