We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!

Able to SDV a CRF through Excel?

Hi Everyone,

Just wondering if there is a way to have Excel VBA connect to the EDC and to SDV on source documents which have been determined by the Excel user.

I was checking the API but may have missed whether it is possible to SDV through code at all.

Thanks!
Tagged:

Comments

  • lindsay.stevenslindsay.stevens Posts: 404 ✭✭✭
    via Email
    Currently there's no API for that, but it's possible to get the job done
    through automated interaction with the HTML pages. Look into Selenium for
    that.

    It might be a little tricky to hook Selenium into vanilla Excel VBA, since
    the closest Selenium driver is C# (VBA can load DLLs). A good alternative
    might be to use Python with the "xlwings" plugin (which you may find useful
    for much more!).



    On 1 Sep. 2017 04:54, "shaundoty"
    wrote:

    OpenClinica https://forums.openclinica.com/
    shaundoty started a new discussion: Able to SDV a CRF through Excel?

    Hi Everyone,

    Just wondering if there is a way to have Excel VBA connect to the EDC and
    to SDV on source documents which have been determined by the Excel user.

    I was checking the API but may have missed whether it is possible to SDV
    through code at all.

    Thanks!
Sign In or Register to comment.