BA and Excel

[gvigliani]

Hi Gary,

why, Betting Assistant don't charge Excel File?

Thank You

[Captain Sensible]

I've had it before when there's an error with the VBA that may have stopped events working in excel. Just check your excel is working and doesn't have some sheet open that was saved with events disabled

[GaryRussell]

When this happens close all Excel instances and try again. On the Excel link screen (it is in your screenshot) click the "Kill all Excel processes" button to make sure all Excel instances are closed before opening the workbook again.

[gvigliani]

Nothing to do. The excel file loads regularly from VB6 and I can see it but the Betting Assistant doesn't match it. There are no other Excel files in memory. Does anyone have a solution?
Windows10 32 Bit
Vb6
Office 2019
(All registered products)

[GaryRussell]

I see you are running the "Click to run" version of office. I think some users have an issue with this. Try installing the .msi version instead. See advice below from Microsoft on how to do this.

Switch from Office Click-to-Run to MSI-based Office
The license is the same. You do not need a new Product Key. If you have any questions, contact Microsoft Support.

Save all work, and then close all programs.
In Control Panel, open Programs and Features to see a list of installed programs.
Click Microsoft Office Click-To-Run 2010, and then click Uninstall.
To remove Microsoft Office Click-to-Run, click Yes.
Go to the Microsoft Office alternative fulfillment page.
Click My account.
Click Download, and then click Advanced options.
Follow the instructions.
To install the MSI-based Microsoft Office edition, run SingleImage.exe.
When prompted, type your Product Key to continue.