Hi, I am calling a python function, which performs a lengthy computation, in VBA using pyxll. I don't really need the return of this function anywhere else in excel or in VBA, as it just saves a csv file when the computation is done, however for the time it takes to finish the computation the sheet is hanging. Is there any way, through asynchronous functions or otherwise, to have the python function run in the background, while I continue to work on the spreadsheet? If you can post some very simple sample code it would be fantastic as ive never worked with asynchronous functions.
Here is what my Python and VBA code look like:
@xl_func("int x, int y")
#writes something in a csv file
and the VBA
Application.Run("foo_to_csv", 0, 1)