Gruss Forum • View topic

by **thunderfoot** » Mon Oct 12, 2009 5:43 pm

I am running Betting Assistant linked to an EXCEL application and all the formula and macros are running nicely in the EXCEL workbook I have open in that application.
I want to run another EXCEL workbook but when I open it in the same EXCEL application I get conflicts with the macros. So I thought I'd open another EXCEL application so that I'd have workbooks completely separate from each other.
But how do I get Betting Assistant to pick-up the 2 workbooks in the the 2 separate EXCEL applications?

by **mak** » Mon Oct 12, 2009 5:47 pm

hi there
try refresh or choose the path of the other workbook

by **GaryRussell** » Mon Oct 12, 2009 5:50 pm

For each instance use the "Browse" button at the top of the "Excel - log current prices" form to select the Excel file.

by **GaryRussell** » Mon Oct 12, 2009 5:53 pm

Sorry, should have pointed out that this feature is only available in the Beta version. See http://www.gruss-software.co.uk/forum/v ... php?t=3922 for download link.

by **thunderfoot** » Mon Oct 12, 2009 6:16 pm

GaryRussell wrote:Sorry, should have pointed out that this feature is only available in the Beta version. See http://www.gruss-software.co.uk/forum/v ... php?t=3922 for download link.

Using 1.1.0.62 version so the features mentioned aren't there.

Question...... I thought everytime you opened BA it would check that you were using the latest version, and if not it would down-load and open the new version automatically?

by **GaryRussell** » Mon Oct 12, 2009 6:18 pm

I am not pushing updates at the moment as it could potentially corrupt everyone's installation. It would be a nightmare. I intend to start the auto updating again when version 1.1.0.63 is released officially.

by **GaryRussell** » Mon Oct 12, 2009 6:20 pm

Also version 1.1.0.63 is a Beta version. Some users might not appreciate a Beta version being forced on them.

by **thunderfoot** » Mon Oct 12, 2009 6:23 pm

thunderfoot wrote:
GaryRussell wrote:Sorry, should have pointed out that this feature is only available in the Beta version. See http://www.gruss-software.co.uk/forum/v ... php?t=3922 for download link.

Using 1.1.0.62 version so the features mentioned aren't there.

Question...... I thought everytime you opened BA it would check that you were using the latest version, and if not it would down-load and open the new version automatically?

Dooh!!! .... should have read the "User Guide from the Help menu in Betting Assistant" :oops:

by **Spike** » Mon Oct 12, 2009 9:21 pm

Surely a better approach would be to solve your macro conflicts? In the end you can only run so many instances of excel.

Often it's just a matter of addressing your macros more fully (for example specifying workbook, worksheet and then range rather than just a range) - although of course I don't know about your specific issues.

This forum is full of VBA bods who'll fix your problems whatever they are.

by **osknows** » Mon Oct 12, 2009 9:46 pm

Usually any refrences to workbook/sheet/range objects in vba should be prefixed by Thisworkbook to ensure code runs only in it's own workbook

eg

Code: Select all: ThisWorkbook.Sheets(1).Range("az5:bb55")

Also, avoid any .activate or .select of objects

Running 2 EXCEL Applications

Running 2 EXCEL Applications

Who is online

Sports betting software from Gruss Software