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: 128
Joined: 24 Jul 2017, 17:02

Excel VBA with aXes

Post by Fairdinkum »

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 2381 times
Fairdinkum
Posts: 128
Joined: 24 Jul 2017, 17:02

Re: Excel VBA with aXes

Post by Fairdinkum »

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 2500 times
Eugene.King
Posts: 10
Joined: 09 Sep 2019, 19:26

Re: Excel VBA with aXes

Post by Eugene.King »

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: 128
Joined: 24 Jul 2017, 17:02

Re: Excel VBA with aXes

Post by Fairdinkum »

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 22370 times
IMG_1142.PNG
IMG_1142.PNG (9.86 MiB) Viewed 22370 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 »

Thanks, I'll give that a try.
Post Reply