×
Discuss about OFS, Temenos Connectors, Various OFS modes, OFS with Versions, OFS performance, Logging, EB.PHANTOM, OFS.SOURCE etc…
Extracting data from T24 to excel file
- poponuts
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
13 years 4 months ago #11971
by poponuts
Extracting data from T24 to excel file was created by poponuts
Hi guys,
Currently, we are migrating from Desktop to browser.
I have a macro-enabled excel which extracts data from Globus Desktop when it is open.
However, I need a similar one from T24 browser.
The problem is I haven't refreshed my memory on Visual Basic since 5 years ago!
There is a piece of line which connects the excel to Globus Desktop:
'Open Desktop connection
Set Desktop = CreateObject("Desktop.Application")
Set App = Desktop.GetApplication("STANDARD.SELECTION")
How do I do that in Internet explorer?
Thanks in advance!
Currently, we are migrating from Desktop to browser.
I have a macro-enabled excel which extracts data from Globus Desktop when it is open.
However, I need a similar one from T24 browser.
The problem is I haven't refreshed my memory on Visual Basic since 5 years ago!
There is a piece of line which connects the excel to Globus Desktop:
'Open Desktop connection
Set Desktop = CreateObject("Desktop.Application")
Set App = Desktop.GetApplication("STANDARD.SELECTION")
How do I do that in Internet explorer?
Thanks in advance!
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2860
- Thank you received: 650
13 years 4 months ago #11974
by jpb
Replied by jpb on topic Re: Extracting data from T24 to excel file
VB won't help here a lot, there is no OLE with browser. Better start refreshing your java-knowledge.
If you would use SEARCH in the forum you will find some other threads dealing with this question, e.g. www.t24all.com/forum/28-t24-administrati...-local-pc.html#11078.
If you would use SEARCH in the forum you will find some other threads dealing with this question, e.g. www.t24all.com/forum/28-t24-administrati...-local-pc.html#11078.
The following user(s) said Thank You: poponuts
Please Log in or Create an account to join the conversation.
- DUBLIN
- Offline
- Elite Member
-
Less
More
- Posts: 202
- Thank you received: 29
13 years 4 months ago #11993
by DUBLIN
Replied by DUBLIN on topic Re: Extracting data from T24 to excel file
Hi poponuts,
Yeap, you can forget about excel downloading by using macros if you're moving to Browser.
Desktop's "thing" is using DDE and it wouldn't work with Browser.
Over the last 3-4 years I've been asking Temenos about any plans for development Excel-Brwoser link (forget about saving enquiries into excel) and answer was "No".
We also have plenty of reports that are using DDE mechanism to get the data from T24 and it is f...g pain !
Yeap, you can forget about excel downloading by using macros if you're moving to Browser.
Desktop's "thing" is using DDE and it wouldn't work with Browser.
Over the last 3-4 years I've been asking Temenos about any plans for development Excel-Brwoser link (forget about saving enquiries into excel) and answer was "No".
We also have plenty of reports that are using DDE mechanism to get the data from T24 and it is f...g pain !
The following user(s) said Thank You: poponuts
Please Log in or Create an account to join the conversation.
- shanthi
- Offline
- Premium Member
-
Less
More
- Posts: 128
- Thank you received: 10
13 years 4 months ago #12243
by shanthi
Replied by shanthi on topic Extracting data from T24 to excel file
Let me know if you are still looking for a solution.
Please Log in or Create an account to join the conversation.
- poponuts
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
13 years 4 months ago #12251
by poponuts
Replied by poponuts on topic Extracting data from T24 to excel file
yes i am still looking for a "free" solution. if you have one, and you would like to share it then it would be greatly appreciated.
however, as per DUBLIN and jpb, it seems like there is unlikely a "macro" solution.
yes, SEARCH would be a good way to look for "old" posts (which I actually did) but was just wondering if there is a solution lately.
however, as per DUBLIN and jpb, it seems like there is unlikely a "macro" solution.
yes, SEARCH would be a good way to look for "old" posts (which I actually did) but was just wondering if there is a solution lately.
Please Log in or Create an account to join the conversation.
- saahmad
- Offline
- Premium Member
-
Less
More
- Posts: 145
- Thank you received: 9
12 years 9 months ago #13409
by saahmad
Replied by saahmad on topic Extracting data from T24 to excel file
I may be wrong here but ask temenos there is a DM tool (Data Migration) from Temenos which you can use for migration using csv or other custom text formats. that would be helpful if you export data to csv from globus.
Please Log in or Create an account to join the conversation.
Time to create page: 0.033 seconds