Hi, I'm finding that SendKeys is somewhat flakey, as noted by many people.

I'm using it in Excel to start and stop an external program, symbol "RLT", but it does not always work, that is it will start but then not stop. The same symbol "ST" is used for both actions.

The steps a

Application.SendKeys ("%")

Application.SendKeys ("RLT")

Application.SendKeys ("ST")

I have read that there is a VBA programmatic alterntive to this, can some please guide me on how to write it?

Many thanks for all help. AM

Hi, I'm finding that SendKeys is somewhat flakey, as noted by many people.

I'm using it in Excel to start and stop an external program, symbol "RLT",
but it does not always work, that is it will start but then not stop. The
same symbol "ST" is used for both actions.

The steps a

Application.SendKeys ("%")

Application.SendKeys ("RLT")

Application.SendKeys ("ST")

I have read that there is a VBA programmatic alterntive to this, can some
please guide me on how to write it?

Many thanks for all help. AM

What is the full name (path\filename) of the program?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Wednesday, February 26, 2020 at 3:21:07 PM UTC-6, GS wrote:
Hi, I'm finding that SendKeys is somewhat flakey, as noted by many people.

I'm using it in Excel to start and stop an external program, symbol "RLT",
but it does not always work, that is it will start but then not stop. The
same symbol "ST" is used for both actions.

The steps a

Application.SendKeys ("%")

Application.SendKeys ("RLT")

Application.SendKeys ("ST")

I have read that there is a VBA programmatic alterntive to this, can some
please guide me on how to write it?

Many thanks for all help. AM

What is the full name (path\filename) of the program?

--
Garry


Hi Garry, good to hear from you!

C:\RealTick\rt332.exe

As always, many thanks for your interest.

On Wednesday, February 26, 2020 at 3:21:07 PM UTC-6, GS wrote:
Hi, I'm finding that SendKeys is somewhat flakey, as noted by many people.

I'm using it in Excel to start and stop an external program, symbol "RLT",
but it does not always work, that is it will start but then not stop. The
same symbol "ST" is used for both actions.

The steps a

Application.SendKeys ("%")

Application.SendKeys ("RLT")

Application.SendKeys ("ST")

I have read that there is a VBA programmatic alterntive to this, can some
please guide me on how to write it?

Many thanks for all help. AM

What is the full name (path\filename) of the program?

--
Garry


Hi Garry, good to hear from you!

C:\RealTick\rt332.exe

As always, many thanks for your interest.

When RT332 is running, what is its window Title?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Thursday, February 27, 2020 at 6:22:38 AM UTC-6, GS wrote:
On Wednesday, February 26, 2020 at 3:21:07 PM UTC-6, GS wrote:
Hi, I'm finding that SendKeys is somewhat flakey, as noted by many people.

I'm using it in Excel to start and stop an external program, symbol "RLT",
but it does not always work, that is it will start but then not stop. The
same symbol "ST" is used for both actions.

The steps a

Application.SendKeys ("%")

Application.SendKeys ("RLT")

Application.SendKeys ("ST")

I have read that there is a VBA programmatic alterntive to this, can some
please guide me on how to write it?

Many thanks for all help. AM

What is the full name (path\filename) of the program?

--
Garry


Hi Garry, good to hear from you!

C:\RealTick\rt332.exe

As always, many thanks for your interest.

When RT332 is running, what is its window Title?

--
Garry


It doesn't have a window of its own. It operates in the background by sending data into Excel. The ribbon has a button named "Realtick ©". Clicking on it produces a drop-down box whose leftmost button is named either "start" or "pause", either starting the data feed or interrupting it. This is the action I'm trying to automate with a macro. It's easy using Sendkeys but, as mentioned, this doesn't always work.

Thanks, Garry

On Thursday, February 27, 2020 at 6:22:38 AM UTC-6, GS wrote:
On Wednesday, February 26, 2020 at 3:21:07 PM UTC-6, GS wrote:
Hi, I'm finding that SendKeys is somewhat flakey, as noted by many
people.

I'm using it in Excel to start and stop an external program, symbol
"RLT", but it does not always work, that is it will start but then not
stop. The same symbol "ST" is used for both actions.

The steps a

Application.SendKeys ("%")

Application.SendKeys ("RLT")

Application.SendKeys ("ST")

I have read that there is a VBA programmatic alterntive to this, can some
please guide me on how to write it?

Many thanks for all help. AM

What is the full name (path\filename) of the program?

--
Garry


Hi Garry, good to hear from you!

C:\RealTick\rt332.exe

As always, many thanks for your interest.

When RT332 is running, what is its window Title?

--
Garry


It doesn't have a window of its own. It operates in the background by
sending data into Excel. The ribbon has a button named "Realtick ©".
Clicking on it produces a drop-down box whose leftmost button is named either
"start" or "pause", either starting the data feed or interrupting it. This
is the action I'm trying to automate with a macro. It's easy using Sendkeys
but, as mentioned, this doesn't always work.

Thanks, Garry

Ok, so why are you using SendKeys if it has Ribbon controls?

Why add an additional macro to run a Ribbon menu when you could just click the
Ribbon menu? (OR you could add those as QAT buttons instead)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Thursday, February 27, 2020 at 11:54:55 AM UTC-6, GS wrote:
On Thursday, February 27, 2020 at 6:22:38 AM UTC-6, GS wrote:
On Wednesday, February 26, 2020 at 3:21:07 PM UTC-6, GS wrote:
Hi, I'm finding that SendKeys is somewhat flakey, as noted by many
people.

I'm using it in Excel to start and stop an external program, symbol
"RLT", but it does not always work, that is it will start but then not
stop. The same symbol "ST" is used for both actions.

The steps a

Application.SendKeys ("%")

Application.SendKeys ("RLT")

Application.SendKeys ("ST")

I have read that there is a VBA programmatic alterntive to this, can some
please guide me on how to write it?

Many thanks for all help. AM

What is the full name (path\filename) of the program?

--
Garry


Hi Garry, good to hear from you!

C:\RealTick\rt332.exe

As always, many thanks for your interest.

When RT332 is running, what is its window Title?

--
Garry


It doesn't have a window of its own. It operates in the background by
sending data into Excel. The ribbon has a button named "Realtick ©".
Clicking on it produces a drop-down box whose leftmost button is named either
"start" or "pause", either starting the data feed or interrupting it. This
is the action I'm trying to automate with a macro. It's easy using Sendkeys
but, as mentioned, this doesn't always work.

Thanks, Garry

Ok, so why are you using SendKeys if it has Ribbon controls?

Why add an additional macro to run a Ribbon menu when you could just click the
Ribbon menu? (OR you could add those as QAT buttons instead)

--
Garry


Because I may need to turn on or off the data feed when I'm not around to click it manually, which happens quite often. As an example, if the market generating the numbers closes at a given hour, the feed must be turned off just prior to the close, or else the numbers received after the close are meaningless.

Because I may need to turn on or off the data feed when I'm not around to
click it manually, which happens quite often. As an example, if the market
generating the numbers closes at a given hour, the feed must be turned off
just prior to the close, or else the numbers received after the close are
meaningless.

Ok, so how are you managing this when not at the computer?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Thursday, February 27, 2020 at 12:44:02 PM UTC-6, GS wrote:
Because I may need to turn on or off the data feed when I'm not around to
click it manually, which happens quite often. As an example, if the market
generating the numbers closes at a given hour, the feed must be turned off
just prior to the close, or else the numbers received after the close are
meaningless.

Ok, so how are you managing this when not at the computer?

--
Garry

With a simple Sendkeys macro (I have shown it in my original post). It works sometimes, sometimes not. That's the reason I thought there may be a "deeper" programmatic way to do it.

Thanks again.

On Thursday, February 27, 2020 at 12:44:02 PM UTC-6, GS wrote:
Because I may need to turn on or off the data feed when I'm not around to
click it manually, which happens quite often. As an example, if the market
generating the numbers closes at a given hour, the feed must be turned off
just prior to the close, or else the numbers received after the close are
meaningless.

Ok, so how are you managing this when not at the computer?

--
Garry

With a simple Sendkeys macro (I have shown it in my original post). It works
sometimes, sometimes not. That's the reason I thought there may be a
"deeper" programmatic way to do it.

Thanks again.

You've only shown lines of code from your macro, not the entire macro code!

You can replace the SendKeys lines with code to call the individual Ribbon
controls that fire those events (start,pause,stop) if they are individual
menuitems. See here...

http://www.rondebruin.nl/win/section2.htm

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Thursday, February 27, 2020 at 1:28:28 PM UTC-6, GS wrote:
On Thursday, February 27, 2020 at 12:44:02 PM UTC-6, GS wrote:
Because I may need to turn on or off the data feed when I'm not around to
click it manually, which happens quite often. As an example, if the market
generating the numbers closes at a given hour, the feed must be turned off
just prior to the close, or else the numbers received after the close are
meaningless.

Ok, so how are you managing this when not at the computer?

--
Garry

With a simple Sendkeys macro (I have shown it in my original post). It works
sometimes, sometimes not. That's the reason I thought there may be a
"deeper" programmatic way to do it.

Thanks again.

You've only shown lines of code from your macro, not the entire macro code!

You can replace the SendKeys lines with code to call the individual Ribbon
controls that fire those events (start,pause,stop) if they are individual
menuitems. See here...

http://www.rondebruin.nl/win/section2.htm

--
Garry



Thanks Garry. That's the whole macro. I schedule it to activate at certain hours of the day to turn the data stream on and off. Since it's really a toggle between "start" and "pause", that's all I need.

On Thursday, February 27, 2020 at 1:28:28 PM UTC-6, GS wrote:
On Thursday, February 27, 2020 at 12:44:02 PM UTC-6, GS wrote:
Because I may need to turn on or off the data feed when I'm not around to
click it manually, which happens quite often. As an example, if the
market generating the numbers closes at a given hour, the feed must be
turned off just prior to the close, or else the numbers received after
the close are meaningless.

Ok, so how are you managing this when not at the computer?

--
Garry

With a simple Sendkeys macro (I have shown it in my original post). It
works sometimes, sometimes not. That's the reason I thought there may be
a "deeper" programmatic way to do it.

Thanks again.

You've only shown lines of code from your macro, not the entire macro code!

You can replace the SendKeys lines with code to call the individual Ribbon
controls that fire those events (start,pause,stop) if they are individual
menuitems. See here...

http://www.rondebruin.nl/win/section2.htm

--
Garry



Thanks Garry. That's the whole macro. I schedule it to activate at certain
hours of the day to turn the data stream on and off. Since it's really a
toggle between "start" and "pause", that's all I need.

I see!
Just so you know, all the RealTick videos I watched on YouTube show a window
with a title; - that suggests there's more to what you are doing with it than
you are letting be known here! What creates the Ribbon menus?

Also, my research finds that RealTick has been replaced with EZE EMS.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Thursday, February 27, 2020 at 2:40:41 PM UTC-6, GS wrote:
On Thursday, February 27, 2020 at 1:28:28 PM UTC-6, GS wrote:
On Thursday, February 27, 2020 at 12:44:02 PM UTC-6, GS wrote:
Because I may need to turn on or off the data feed when I'm not around to
click it manually, which happens quite often. As an example, if the
market generating the numbers closes at a given hour, the feed must be
turned off just prior to the close, or else the numbers received after
the close are meaningless.

Ok, so how are you managing this when not at the computer?

--
Garry

With a simple Sendkeys macro (I have shown it in my original post). It
works sometimes, sometimes not. That's the reason I thought there may be
a "deeper" programmatic way to do it.

Thanks again.

You've only shown lines of code from your macro, not the entire macro code!

You can replace the SendKeys lines with code to call the individual Ribbon
controls that fire those events (start,pause,stop) if they are individual
menuitems. See here...

http://www.rondebruin.nl/win/section2.htm

--
Garry



Thanks Garry. That's the whole macro. I schedule it to activate at certain
hours of the day to turn the data stream on and off. Since it's really a
toggle between "start" and "pause", that's all I need.

I see!
Just so you know, all the RealTick videos I watched on YouTube show a window
with a title; - that suggests there's more to what you are doing with it than
you are letting be known here! What creates the Ribbon menus?

Also, my research finds that RealTick has been replaced with EZE EMS.

--
Garry


Indeed Garry, thanks for getting into it. RealTick is mostly used from the page you saw on YouTube, the real-time data ia fed into that page.

However, upon installation there's an option which works with Excel, it is in fact one of the very few programs that do this, I've been using it for years. The data is called from formulas entered into Excel, and updates in real-time as well. The numbers are then manipulated by the user (myself) within Excel. I like it because it allows me to do my own analysis and not depend on some "canned" program. As I mentioned, it sits on the ribbon as "Realtick ©".

My version of the program is RealTick EMS 11.2, I believe it provides (upon installation, of course) the most recent version of RealTick for Excel.

Thanks again for always taking time to help me out. If I may say so, you're one hell of a teacher.

Indeed Garry, thanks for getting into it. RealTick is mostly used from the
page you saw on YouTube, the real-time data ia fed into that page.

However, upon installation there's an option which works with Excel, it is
in fact one of the very few programs that do this, I've been using it for
years. The data is called from formulas entered into Excel, and updates in
real-time as well. The numbers are then manipulated by the user (myself)
within Excel. I like it because it allows me to do my own analysis and not
depend on some "canned" program. As I mentioned, it sits on the ribbon as
"Realtick ©".

My version of the program is RealTick EMS 11.2, I believe it provides (upon
installation, of course) the most recent version of RealTick for Excel.

Ok, so that suggests it includes an Addin or a COMAddin that puts its own tab
on the Excel Ribbon, OR adds its own menu to an existing RibbOn tab; - which is
it?

If it is an Addin then it uses a .XLAM workbook to add the menus, and contains
associated macros. If so, can you provide a download link to that workbook?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Thursday, February 27, 2020 at 5:03:19 PM UTC-6, GS wrote:
Indeed Garry, thanks for getting into it. RealTick is mostly used from the
page you saw on YouTube, the real-time data ia fed into that page.

However, upon installation there's an option which works with Excel, it is
in fact one of the very few programs that do this, I've been using it for
years. The data is called from formulas entered into Excel, and updates in
real-time as well. The numbers are then manipulated by the user (myself)
within Excel. I like it because it allows me to do my own analysis and not
depend on some "canned" program. As I mentioned, it sits on the ribbon as
"Realtick ©".

My version of the program is RealTick EMS 11.2, I believe it provides (upon
installation, of course) the most recent version of RealTick for Excel.

Ok, so that suggests it includes an Addin or a COMAddin that puts its own tab
on the Excel Ribbon, OR adds its own menu to an existing RibbOn tab; - which is
it?

If it is an Addin then it uses a .XLAM workbook to add the menus, and contains
associated macros. If so, can you provide a download link to that workbook?

--
Garry


The user does nothing. The installation proecedure for RealTick does it. Once Excel is started after installation, the "ReaTick ©" button appears in the rightmost spot of the ribbon.

Thanks Garry.

On Thursday, February 27, 2020 at 5:03:19 PM UTC-6, GS wrote:
Indeed Garry, thanks for getting into it. RealTick is mostly used from the
page you saw on YouTube, the real-time data ia fed into that page.

However, upon installation there's an option which works with Excel, it is
in fact one of the very few programs that do this, I've been using it for
years. The data is called from formulas entered into Excel, and updates in
real-time as well. The numbers are then manipulated by the user (myself)
within Excel. I like it because it allows me to do my own analysis and not
depend on some "canned" program. As I mentioned, it sits on the ribbon as
"Realtick ©".

My version of the program is RealTick EMS 11.2, I believe it provides (upon
installation, of course) the most recent version of RealTick for Excel.

Ok, so that suggests it includes an Addin or a COMAddin that puts its own
tab on the Excel Ribbon, OR adds its own menu to an existing RibbOn tab; -
which is it?

If it is an Addin then it uses a .XLAM workbook to add the menus, and
contains associated macros. If so, can you provide a download link to that
workbook?

--
Garry


The user does nothing. The installation proecedure for RealTick does it.
Once Excel is started after installation, the "ReaTick ©" button appears in
the rightmost spot of the ribbon.

Thanks Garry.

This indicates that it's an addin so what I'm asking is for you to check if
it's a workbook.xlam or a COMAddin via the Developer tab. Please & thank you!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Friday, February 28, 2020 at 11:12:33 AM UTC-6, GS wrote:
On Thursday, February 27, 2020 at 5:03:19 PM UTC-6, GS wrote:
Indeed Garry, thanks for getting into it. RealTick is mostly used from the
page you saw on YouTube, the real-time data ia fed into that page.

However, upon installation there's an option which works with Excel, it is
in fact one of the very few programs that do this, I've been using it for
years. The data is called from formulas entered into Excel, and updates in
real-time as well. The numbers are then manipulated by the user (myself)
within Excel. I like it because it allows me to do my own analysis and not
depend on some "canned" program. As I mentioned, it sits on the ribbon as
"Realtick ©".

My version of the program is RealTick EMS 11.2, I believe it provides (upon
installation, of course) the most recent version of RealTick for Excel.

Ok, so that suggests it includes an Addin or a COMAddin that puts its own
tab on the Excel Ribbon, OR adds its own menu to an existing RibbOn tab; -
which is it?

If it is an Addin then it uses a .XLAM workbook to add the menus, and
contains associated macros. If so, can you provide a download link to that
workbook?

--
Garry


The user does nothing. The installation proecedure for RealTick does it.
Once Excel is started after installation, the "ReaTick ©" button appears in
the rightmost spot of the ribbon.

Thanks Garry.

This indicates that it's an addin so what I'm asking is for you to check if
it's a workbook.xlam or a COMAddin via the Developer tab. Please & thank you!

--
Garry


Under Excel Add-ins, 2 lines:

Name: RealTickForExcelIUI
Location: c:\RealTick\Excel\adxloader.dll
Description: PDFelement 7 Add-in

Name: RealTickRTD.dataserver
Location: c:\RealTick\RealTickRtd.dll
Description: DataServer Class

Unfortunately I don't know how to find "workbook.xlam" or "COMAddin".

Many thanks.

On Friday, February 28, 2020 at 11:12:33 AM UTC-6, GS wrote:
On Thursday, February 27, 2020 at 5:03:19 PM UTC-6, GS wrote:
Indeed Garry, thanks for getting into it. RealTick is mostly used from
the page you saw on YouTube, the real-time data ia fed into that page.

However, upon installation there's an option which works with Excel, it
is in fact one of the very few programs that do this, I've been using it
for years. The data is called from formulas entered into Excel, and
updates in real-time as well. The numbers are then manipulated by the
user (myself) within Excel. I like it because it allows me to do my own
analysis and not depend on some "canned" program. As I mentioned, it
sits on the ribbon as "Realtick ©".

My version of the program is RealTick EMS 11.2, I believe it provides
(upon installation, of course) the most recent version of RealTick for
Excel.

Ok, so that suggests it includes an Addin or a COMAddin that puts its own
tab on the Excel Ribbon, OR adds its own menu to an existing RibbOn tab;
- which is it?

If it is an Addin then it uses a .XLAM workbook to add the menus, and
contains associated macros. If so, can you provide a download link to
that workbook?

--
Garry


The user does nothing. The installation proecedure for RealTick does it.
Once Excel is started after installation, the "ReaTick ©" button appears in
the rightmost spot of the ribbon.

Thanks Garry.

This indicates that it's an addin so what I'm asking is for you to check if
it's a workbook.xlam or a COMAddin via the Developer tab. Please & thank
you!

--
Garry


Under Excel Add-ins, 2 lines:

Name: RealTickForExcelIUI
Location: c:\RealTick\Excel\adxloader.dll
Description: PDFelement 7 Add-in

Name: RealTickRTD.dataserver
Location: c:\RealTick\RealTickRtd.dll
Description: DataServer Class

Unfortunately I don't know how to find "workbook.xlam" or "COMAddin".

Many thanks.

Ok thanks! This suggests a COMAddin or VSTO addin since it's a DLL so I'll look
into trying to access the menuitems directly w/VBA. You say it's a dropdown
menu? Please describe what happens when you click it...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Friday, February 28, 2020 at 12:07:56 PM UTC-6, GS wrote:
On Friday, February 28, 2020 at 11:12:33 AM UTC-6, GS wrote:
On Thursday, February 27, 2020 at 5:03:19 PM UTC-6, GS wrote:
Indeed Garry, thanks for getting into it. RealTick is mostly used from
the page you saw on YouTube, the real-time data ia fed into that page.

However, upon installation there's an option which works with Excel, it
is in fact one of the very few programs that do this, I've been using it
for years. The data is called from formulas entered into Excel, and
updates in real-time as well. The numbers are then manipulated by the
user (myself) within Excel. I like it because it allows me to do my own
analysis and not depend on some "canned" program. As I mentioned, it
sits on the ribbon as "Realtick ©".

My version of the program is RealTick EMS 11.2, I believe it provides
(upon installation, of course) the most recent version of RealTick for
Excel.

Ok, so that suggests it includes an Addin or a COMAddin that puts its own
tab on the Excel Ribbon, OR adds its own menu to an existing RibbOn tab;
- which is it?

If it is an Addin then it uses a .XLAM workbook to add the menus, and
contains associated macros. If so, can you provide a download link to
that workbook?

--
Garry


The user does nothing. The installation proecedure for RealTick does it.
Once Excel is started after installation, the "ReaTick ©" button appears in
the rightmost spot of the ribbon.

Thanks Garry.

This indicates that it's an addin so what I'm asking is for you to check if
it's a workbook.xlam or a COMAddin via the Developer tab. Please & thank
you!

--
Garry


Under Excel Add-ins, 2 lines:

Name: RealTickForExcelIUI
Location: c:\RealTick\Excel\adxloader.dll
Description: PDFelement 7 Add-in

Name: RealTickRTD.dataserver
Location: c:\RealTick\RealTickRtd.dll
Description: DataServer Class

Unfortunately I don't know how to find "workbook.xlam" or "COMAddin".

Many thanks.

Ok thanks! This suggests a COMAddin or VSTO addin since it's a DLL so I'll look
into trying to access the menuitems directly w/VBA. You say it's a dropdown
menu? Please describe what happens when you click it...



Dropdown menu has 6 sections, each with several sub-sections listed below:

1. Control

a. Pause: Start/Pause Streaming Data | RealTickForExcelIUI

b. Refresh: Refresh Data | RealTickForExcelIUI

2. Data

a. Market: Invoke Market Data Setup | RealTickForExcelIUI

b. Historic: Invoke Historic Data Setup | RealTickForExcelIUI


3. Insert symbols

a. Load Symbols | RealTickForExcelIUI

b. Search Symbols | RealTickForExcelIUI


4. Insert Fields

a. Load Fields | RealTickForExcelIUI

b. Search Fields | RealTickForExcelIUI


5. Trading

a. Create Order Grid | RealTickForExcelIUI

b. Create Positions Grid | RealTickForExcelIUI

c. Create Account Balance Grid | RealTickForExcelIUI



6. Service Center

a. Select to customize Excel settings | RealTickForExcelIUI

b. Resolve path name for RealTick macros | RealTickForExcelIUI

c. Download templates RealTickForExcelIUI

d. Connect to Updates & Download Central | RealTickForExcelIUI

e. Connect to Help Desk | RealTickForExcelIUI

f. About RealTick for Microsoft Excel | RealTickForExcelIUI

On Friday, February 28, 2020 at 12:07:56 PM UTC-6, GS wrote:
On Friday, February 28, 2020 at 11:12:33 AM UTC-6, GS wrote:
On Thursday, February 27, 2020 at 5:03:19 PM UTC-6, GS wrote:
Indeed Garry, thanks for getting into it. RealTick is mostly used from
the page you saw on YouTube, the real-time data ia fed into that page.

However, upon installation there's an option which works with Excel,
it is in fact one of the very few programs that do this, I've been
using it for years. The data is called from formulas entered into
Excel, and updates in real-time as well. The numbers are then
manipulated by the user (myself) within Excel. I like it because it
allows me to do my own analysis and not depend on some "canned"
program. As I mentioned, it sits on the ribbon as "Realtick ©".

My version of the program is RealTick EMS 11.2, I believe it provides
(upon installation, of course) the most recent version of RealTick for
Excel.

Ok, so that suggests it includes an Addin or a COMAddin that puts its
own tab on the Excel Ribbon, OR adds its own menu to an existing
RibbOn tab; - which is it?

If it is an Addin then it uses a .XLAM workbook to add the menus, and
contains associated macros. If so, can you provide a download link to
that workbook?

--
Garry


The user does nothing. The installation proecedure for RealTick does it.
Once Excel is started after installation, the "ReaTick ©" button
appears in the rightmost spot of the ribbon.

Thanks Garry.

This indicates that it's an addin so what I'm asking is for you to check
if it's a workbook.xlam or a COMAddin via the Developer tab. Please &
thank you!

--
Garry


Under Excel Add-ins, 2 lines:

Name: RealTickForExcelIUI
Location: c:\RealTick\Excel\adxloader.dll
Description: PDFelement 7 Add-in

Name: RealTickRTD.dataserver
Location: c:\RealTick\RealTickRtd.dll
Description: DataServer Class

Unfortunately I don't know how to find "workbook.xlam" or "COMAddin".

Many thanks.

Ok thanks! This suggests a COMAddin or VSTO addin since it's a DLL so I'll
look into trying to access the menuitems directly w/VBA. You say it's a
dropdown menu? Please describe what happens when you click it...



Dropdown menu has 6 sections, each with several sub-sections listed below:

1. Control

a. Pause: Start/Pause Streaming Data | RealTickForExcelIUI

b. Refresh: Refresh Data | RealTickForExcelIUI

2. Data

a. Market: Invoke Market Data Setup | RealTickForExcelIUI

b. Historic: Invoke Historic Data Setup | RealTickForExcelIUI


3. Insert symbols

a. Load Symbols | RealTickForExcelIUI

b. Search Symbols | RealTickForExcelIUI


4. Insert Fields

a. Load Fields | RealTickForExcelIUI

b. Search Fields | RealTickForExcelIUI


5. Trading

a. Create Order Grid | RealTickForExcelIUI

b. Create Positions Grid | RealTickForExcelIUI

c. Create Account Balance Grid | RealTickForExcelIUI



6. Service Center

a. Select to customize Excel settings | RealTickForExcelIUI

b. Resolve path name for RealTick macros | RealTickForExcelIUI

c. Download templates RealTickForExcelIUI

d. Connect to Updates & Download Central | RealTickForExcelIUI

e. Connect to Help Desk | RealTickForExcelIUI

f. About RealTick for Microsoft Excel | RealTickForExcelIUI

Does 6e offer anything helpful?
Does RealTick.exe have a userguide (CHM) in its folder?

I applied for the trial to see for myself how your addin works. Perhaps their
enthusiasm to bring me onboard will be in our favor!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Does 6e offer anything helpful?

Not much that I can see. Mostly a selling job for their services.


Does RealTick.exe have a userguide (CHM) in its folder?

I can't see one. However, there's hundred of files so it's hard for me to discern what may be useful. I don't suppose they are interested in revealing the inner workings of their programs, especially to true mavens like yourself!

I applied for the trial to see for myself how your addin works. Perhaps their
enthusiasm to bring me onboard will be in our favor!


Man, Garry, this is really going beyond the call of duty! Thanks so much. Have a great weekend.

I can't see one. However, there's hundred of files so it's hard for me to
discern what may be useful.

What happens when you click Help in the EXE?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Friday, February 28, 2020 at 4:39:34 PM UTC-6, GS wrote:
I can't see one. However, there's hundred of files so it's hard for me to
discern what may be useful.

What happens when you click Help in the EXE?

--
Clicking Help after opening rt332.exe brings up a listing:

Help
Jump to our home page

Output memory info
Show Application perms
Show trading perms
Remote support session
Clear cache data
Diagnostics

Export files for support

Refresh permissions

About RealTick

On Friday, February 28, 2020 at 4:39:34 PM UTC-6, GS wrote:
I can't see one. However, there's hundred of files so it's hard for me to
discern what may be useful.

What happens when you click Help in the EXE?

--
Clicking Help after opening rt332.exe brings up a listing:

Help
Jump to our home page

Output memory info
Show Application perms
Show trading perms
Remote support session
Clear cache data
Diagnostics

Export files for support

Refresh permissions

About RealTick

Hhmm...! So then what happens when you click Help Help?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Monday, March 2, 2020 at 7:37:24 PM UTC-6, GS wrote:
On Friday, February 28, 2020 at 4:39:34 PM UTC-6, GS wrote:
I can't see one. However, there's hundred of files so it's hard for me to
discern what may be useful.

What happens when you click Help in the EXE?

--
Clicking Help after opening rt332.exe brings up a listing:

Help
Jump to our home page

Output memory info
Show Application perms
Show trading perms
Remote support session
Clear cache data
Diagnostics

Export files for support

Refresh permissions

About RealTick

Hhmm...! So then what happens when you click Help Help?

--

Actually the line reads "Help F1"

Nothing happens either pressing the F1 key or clicking on "Help".

On Monday, March 2, 2020 at 7:37:24 PM UTC-6, GS wrote:
On Friday, February 28, 2020 at 4:39:34 PM UTC-6, GS wrote:
I can't see one. However, there's hundred of files so it's hard for me
to discern what may be useful.

What happens when you click Help in the EXE?

--
Clicking Help after opening rt332.exe brings up a listing:

Help
Jump to our home page

Output memory info
Show Application perms
Show trading perms
Remote support session
Clear cache data
Diagnostics

Export files for support

Refresh permissions

About RealTick

Hhmm...! So then what happens when you click Help Help?

--

Actually the line reads "Help F1"

Nothing happens either pressing the F1 key or clicking on "Help".

So there's no access to help/userguide?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Tuesday, March 3, 2020 at 2:29:52 PM UTC-6, GS wrote:

So there's no access to help/userguide?



That seems to be the case. I guess I could call them and ask why.