Excel VBA compile error - BF Historic data sheet

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
plasteredric
Posts: 65
Joined: Thu Nov 19, 2020 4:52 pm

I'm trying to get the bf historic data spreadsheet to work but I keep getting the compile error shown below and I can't figure out what the issue is, if anyone has any suggestions.

Code: Select all

Private Function sNodeType(NodeParm As Node) As String
Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

Try fully declaring the library that node comes from

Code: Select all

Private Function sNodeType(NodeParm As MSComctlLib.Node) As String
plasteredric
Posts: 65
Joined: Thu Nov 19, 2020 4:52 pm

ODPaul82 wrote:
Mon Mar 08, 2021 6:59 am
Try fully declaring the library that node comes from

Code: Select all

Private Function sNodeType(NodeParm As MSComctlLib.Node) As String
Thanks for taking the time to look into it. I did try what you said but it still gave me the same error.
I had suspected that it might be related to the out-dated version of excel I was using so I've (reluctantly) stumped up the cash and got office 365 which has solved the issue.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”