Hello, I have an active x exe made in vb6.
which does this:
for i = 1 to 10
sleep (2000) 'pause for 2 seconds
I register this exe and add reference to it in ms excel.
I then reference the object using the CreateObject syntax and run the procedure 'Test'
I thought that being an exe, while this runs in excel, i will be still able to type in the cells (i.e. I thought that being an exe, it would run in its own memory space...) but i have to wait for the whole procedure from the exe to finish before i can do anything in excel.
How can I have the workbook multitasking, i.e typing in cells while this exe runs the procedure..?