Names of Linked workbooks- Gaurdian -Excel

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
bigtimesmallshot
Posts: 18
Joined: Fri May 24, 2019 9:41 pm

I've created a spreadhseet to link odds in BF for BTTS compared to my stats formulas to show potential value , It's a set of sheets using linked cells and power query .

I'm using a version of the betangel multiple.xls whereby I have created multiple workbooks and renamed them 1, 2, 3, etc .

However , the "auto bind Bet angel sheets " does not seem to work when I load the markets in , I have to manually insert what sheet each market is linked to , especially on Saturdays and Sundays it's a pain !!

My question is ; do the work books need to have the original names (betangel (1) , betangel (2) ) etc for auto binding to work ? , when I select it nothing happens and I'm guessing it's to do with the names of the workbooks ?

Any help would be appreciated .
Spreadsheet.png




Gaurdian.png
You do not have the required permissions to view the files attached to this post.
ODPaul82
Posts: 204
Joined: Sun May 08, 2011 6:32 am
Location: Sutton

Short answer, yes, they still need to have Bet Angel at the front of the sheet name
bigtimesmallshot
Posts: 18
Joined: Fri May 24, 2019 9:41 pm

Thank you kindly - guess I am renaming lots of them so ....
ODPaul82
Posts: 204
Joined: Sun May 08, 2011 6:32 am
Location: Sutton

bigtimesmallshot wrote:
Fri Mar 12, 2021 11:56 am
Thank you kindly - guess I am renaming lots of them so ....
Just automate it

drop into code view (Alt-F11) and put the following into a code module

Code: Select all

Private Sub mRenameSheets()
    Dim objWs As Excel.Worksheet
    
    For Each objWs In ThisWorkbook.Worksheets
        If Left(objWs.Name, 9) <> "Bet Angel" Then objWs.Name = "Bet Angel - " & objWs.Name
    Next objWs
    
    Set objWs = Nothing
End Sub
bigtimesmallshot
Posts: 18
Joined: Fri May 24, 2019 9:41 pm

ah excellent ! - Thanks a million !! - will try now
bigtimesmallshot
Posts: 18
Joined: Fri May 24, 2019 9:41 pm

Wow - that was quick !!!- brilliant and thanks again ODPaul
JAMESGLYNN67
Posts: 22
Joined: Wed Aug 22, 2018 6:40 pm

Is there a maximum number of sheets that can be copied and/or linked to guardian? Mine wont auto-bind more than 6 automatically and only 10 in total manually
ODPaul82
Posts: 204
Joined: Sun May 08, 2011 6:32 am
Location: Sutton

If you've got restrict refresh applied then it will only bind anything that is due within the refresh timeframe.
Just done a test and it autobinds 20 worksheets fine for me where restrict refresh is not applied.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”