Excel VBA with aXes

Use this Forum to post tips and techniques for using aXes. Please explain in detail. This Forum is managed by the aXes user community. LANSA cannot guarantee the accuracy of any information posted to this Forum.

Moderator: jeanmichel

Post Reply
Fairdinkum
Posts: 119
Joined: 24 Jul 2017, 17:02

Excel VBA with aXes

Post by Fairdinkum » 05 Jun 2019, 16:37

Hi,

To meet a prospect's demand, I've prepared a project which allows users to retrieve/set values on Excel spread sheet from/to an aXes screen.
Video is here:
https://drive.google.com/open?id=1Cei-v ... axJoBtDKVf

Attached save file is the sample project shown in the video above.

Best Regards,
Hidekazu Tanaka
Attachments
workwithvba.zip
(316.14 KiB) Downloaded 2165 times

Fairdinkum
Posts: 119
Joined: 24 Jul 2017, 17:02

Re: Excel VBA with aXes

Post by Fairdinkum » 05 Jun 2019, 19:14

Hi,

I have updated the project.

Video:
https://drive.google.com/open?id=1RvuiQ ... ZzhMPlPanX

Best Regards,
Hidekazu Tanaka
Attachments
workwithvba.zip
(452.39 KiB) Downloaded 2251 times

Eugene.King
Posts: 10
Joined: 09 Sep 2019, 19:26

Re: Excel VBA with aXes

Post by Eugene.King » 19 Oct 2022, 00:32

Do you have a translated version of this document, please? I'm looking to do something similar with both excel and word. Thanks in advance.

Fairdinkum
Posts: 119
Joined: 24 Jul 2017, 17:02

Re: Excel VBA with aXes

Post by Fairdinkum » 19 Oct 2022, 10:36

Hi Eugene.King,

Thanks for having interest in this sample. Unfortunately, there is no translated documentation. You might want to use a translate app (say the google lens app) instead. I believe it helps you something like the followings.
IMG_1141.PNG
IMG_1141.PNG (8.72 MiB) Viewed 13396 times
IMG_1142.PNG
IMG_1142.PNG (9.86 MiB) Viewed 13396 times


Note:
If my understanding is correct, some APIs in this VBA work on only IE11 (not Chrome/Edge/Firefox). These may work on Edge IE mode, though, I didn't test.

Hope this helps!

Regards,
Hide

Eugene.King
Posts: 10
Joined: 09 Sep 2019, 19:26

Re: Excel VBA with aXes

Post by Eugene.King » 19 Oct 2022, 19:25

Thanks, I'll give that a try.

Post Reply