Hi,

I have an excel file with eikon formulas and macros to update spot, swap points and do some math etc... I would like to launch that excel file using Python and execute the excel's macros also with Python. Manually everything works but when I use Xlwings or win32com to launch the excel with python, the dates are 00/01/1900 and every FX spot is at 0 and when I try to refresh manually or with python nothing works.

The Add in is connected and I am logged in so it should work.

My python script works when I open and run macro on excel that do not use eikon data.

import xlwings
import time

def run_macro (work_book_path: str, *args: str):
    """Run macro from a workbook

    Args:
        work_book_path (str): macro's name
    """
    wb = xlwings.Book(work_book_path)

    time.sleep(10)

    for macro in args:
        print(f"running {macro}")
        running_macro = wb.macro(macro)
        running_macro()
        time.sleep(3)

run_macro(PATH_UMILP_P2, 
          "Module1.macro1", 
          "Module1.macro2", 
          "Module1.macro3",
          "Module1.macro4"
          )