forcing DSGRID Excel formula to calculate while a VBA macro is running

hugobrown1
hugobrown1 Newcomer
edited April 11 in Datastream

Hi Community

Im use VBA  macros to open many files with DSgrid formula in them, I need them to update their values when they a re opened by the macro. As I'm looping through many files I do not want a manual step that involves stopping the VBA. Is this possible? Below is a screen shot of my formula.

image.png

many thanks

Hugo

Tagged:

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @hugobrown1

    Thank you for reaching out to us.

    This forum is dedicated to software developers using LSEG APIs.

    For questions about DSGRID in Excel, please contact the product support team directly via MyAccount.

Categories