How is it possible to import trt file ?

Talk about anything at all....
Post Reply
pLil
Posts: 5
Joined: Tue Jun 03, 2014 11:13 am

How is it possible to import trt file ?

Post 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!
Last edited by pLil on Tue Jun 03, 2014 11:42 am, edited 1 time in total.
OpenOffice 4.0.0
User avatar
RoryOF
Moderator
Posts: 34571
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How it is possible to import trt file ?

Post by RoryOF »

Not supported by anything but its originating program, as far as I can ascertain.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
pLil
Posts: 5
Joined: Tue Jun 03, 2014 11:13 am

Re: How it is possible to import trt file ?

Post by pLil »

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 ?

Post 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.)?
OpenOffice 4.0.0
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How is it possible to import trt file ?

Post 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
pLil
Posts: 5
Joined: Tue Jun 03, 2014 11:13 am

Re: How is it possible to import trt file ?

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

Re: How is it possible to import trt file ?

Post 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
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
jrkrideau
Volunteer
Posts: 3816
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: How is it possible to import trt file ?

Post 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
LibreOffice 7.3.7. 2; Ubuntu 22.04
User avatar
RoryOF
Moderator
Posts: 34571
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How is it possible to import trt file ?

Post 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.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Mark Nelson
Posts: 107
Joined: Sat Nov 24, 2007 5:26 pm

Re: How is it possible to import trt file ?

Post 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).
Windows 10
OpenOffice.org 4.1.1 LibreOffice 5.01
Post Reply