Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

VBA for Excel - calling API

  • Amaury VAN ESPEN
  • Amaury VAN ESPEN's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 8 months ago - 1 year 8 months ago #241087 by Amaury VAN ESPEN
VBA for Excel - calling API was created by Amaury VAN ESPEN
Hello,
i've an issue with the script suggested here
forums.limesurvey.org/forum/development/...otecontrol2-json-rpc

[img


Could you please provide insights ?
Thank you
Amaury
Attachments:
Last edit: 1 year 8 months ago by c_schmitz.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 year 8 months ago #241089 by holch
Replied by holch on topic VBA for Excel - calling API
Please do NOT copy and paste images into the WYSIWYG Editor, it will just come out as "code salad".
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • Amaury VAN ESPEN
  • Amaury VAN ESPEN's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 8 months ago #241115 by Amaury VAN ESPEN
Replied by Amaury VAN ESPEN on topic VBA for Excel - calling API
Hello,
message updated with file attached,
it seems there is an issue with this Sub not defined
Decode64(export64)
I've found this code to complete this part, but does not run properly locally, may it is something missing with my version of excel ? or a .dll required ? could you please help ?
stackoverflow.com/questions/169907/how-d...ntly-using-excel-vba
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
1 year 8 months ago #241119 by DenisChenu
Replied by DenisChenu on topic VBA for Excel - calling API

it seems there is an issue with this Sub not defined
Decode64(export64)

 
Seems you are totally right,

Did you try to copy web.archive.org/web/20060527094535/https...ecode-base64-vb6.asp in your excel VBA ?

 
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.

Please Log in to join the conversation.

  • Amaury VAN ESPEN
  • Amaury VAN ESPEN's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 8 months ago #241129 by Amaury VAN ESPEN
Replied by Amaury VAN ESPEN on topic VBA for Excel - calling API
Hello
yes, 've just tried,
unfortunately, another error, please see attachment,

does someone has a running workbook to share ?
Thank you
Amaury 

Please Log in to join the conversation.

  • Amaury VAN ESPEN
  • Amaury VAN ESPEN's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 8 months ago #241142 by Amaury VAN ESPEN
Replied by Amaury VAN ESPEN on topic VBA for Excel - calling API
Hello
New issue using ToBase64 but about the type of variable export.
Please see attachement
Thanks for your help, still not resolve
Regards
Amaury
Attachments:

Please Log in to join the conversation.

Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source