Hi
I wondered if there was any plan / intention to update the VBA scripts in HYPTUSS to Office Script / Office.js so that they will work in a web based version of excel?
Full disclosure, I’m not a programmer so only know of the above terms due to investigations I’ve undertaken after getting an error message in the online version of excel.
The error message is:
‘This version of Excel cannot run via macros’
The script I would love to work online is the one for the FT Funds page of HYPTUSS which is incredibly useful. Is anyone able to provide an office script ‘ office.js version of the script from that particular page?
Thanks in advance
Femi
Got a credit card? use our Credit Card & Finance Calculators
Thanks to smokey01,bungeejumper,stockton,Anonymous,bruncher, for Donating to support the site
HYPTUSS - VBA to office script / js?
-
- Lemon Quarter
- Posts: 3326
- Joined: December 7th, 2016, 9:09 pm
- Has thanked: 381 times
- Been thanked: 1101 times
Re: HYPTUSS - VBA to office script / js?
Femi wrote:Hi
I wondered if there was any plan / intention to update the VBA scripts in HYPTUSS to Office Script / Office.js so that they will work in a web based version of excel?
Full disclosure, I’m not a programmer so only know of the above terms due to investigations I’ve undertaken after getting an error message in the online version of excel.
The error message is:
‘This version of Excel cannot run via macros’
The script I would love to work online is the one for the FT Funds page of HYPTUSS which is incredibly useful. Is anyone able to provide an office script ‘ office.js version of the script from that particular page?
Thanks in advance
Femi
I believe that would require a programmer/maintainer interested in supporting "Office Script".
Are you volunteering?
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Seriously though, have you considered installing LibreOffice in order to run HYPTUSS.
That's what I use.
Another alternative that I have investigated is building a macro in Google sheets to perform the ranking task. I did this when there was a problem with the Yahoo API, as the googlefincance function still worked. I succeeded, then abandoned the project as our wonderful HYPTUSS maintainers produced a solution.
BTW, what is it that runs Office.js for curiosity? I'm assuming it's based upon Java Script.
-
- Lemon Pip
- Posts: 51
- Joined: January 20th, 2022, 10:28 pm
- Has thanked: 10 times
- Been thanked: 30 times
Re: HYPTUSS - VBA to office script / js?
Urbandreamer wrote:
I believe that would require a programmer/maintainer interested in supporting "Office Script".
Are you volunteering?![]()
Seriously though, have you considered installing LibreOffice in order to run HYPTUSS.
That's what I use.
Another alternative that I have investigated is building a macro in Google sheets to perform the ranking task. I did this when there was a problem with the Yahoo API, as the googlefincance function still worked. I succeeded, then abandoned the project as our wonderful HYPTUSS maintainers produced a solution.
BTW, what is it that runs Office.js for curiosity? I'm assuming it's based upon Java Script.
If only I were a programmer
![Laughing :lol:](./images/smilies/icon_lol.gif)
From what I have summised, yes .js is javascript and it runs in the MS Office suite of applications?
Regards
Femi
-
- Lemon Quarter
- Posts: 4149
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3308 times
- Been thanked: 2876 times
Re: HYPTUSS - VBA to office script / js?
Femi wrote:Hi
I wondered if there was any plan / intention to update the VBA scripts in HYPTUSS to Office Script / Office.js so that they will work in a web based version of excel?
Thanks in advance
Femi
Sorry, no plans for this. My aged brain has enough problems with Python and VBA, without delving into anything but the most basic javascript
--kiloran
-
- Lemon Pip
- Posts: 51
- Joined: January 20th, 2022, 10:28 pm
- Has thanked: 10 times
- Been thanked: 30 times
Re: HYPTUSS - VBA to office script / js?
kiloran wrote:Sorry, no plans for this. My aged brain has enough problems with Python and VBA, without delving into anything but the most basic javascript
--kiloran
I bet - no worries, worth asking
![Smile :)](./images/smilies/icon_e_smile.gif)
-
- Lemon Slice
- Posts: 460
- Joined: November 4th, 2016, 4:55 pm
- Has thanked: 163 times
- Been thanked: 162 times
Re: HYPTUSS - VBA to office script / js?
Femi wrote:kiloran wrote:Sorry, no plans for this. My aged brain has enough problems with Python and VBA, without delving into anything but the most basic javascript
--kiloran
I bet - no worries, worth askingThanks for all you do buddy
Sounds like a job for ChatGPT. Isn't it supposed to be good at programming?
Adrian
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 7 guests