Hi,
I'm using VBA to call an API (Untappd) and extract a number of datapoints. This is working fine for me for all the fields I want, other than one called "count".
When I write what I need to get the data:
Producer.response.brewery.rating.count
VBA automatically renames it to
Producer.response.brewery.rating.Count (capitalising the C of count)
Which then errors with "Object doesn't support this property or method".
Is there a way to prevent Excel from deciding that .count is to use the inbuilt Count property, but is in fact the field name? I've tried many different ideas of what I can do to make it believe it's a field, e.g. "count", [count] etc but it doesn't allow any of them.
Thanks!
I'm using VBA to call an API (Untappd) and extract a number of datapoints. This is working fine for me for all the fields I want, other than one called "count".
When I write what I need to get the data:
Producer.response.brewery.rating.count
VBA automatically renames it to
Producer.response.brewery.rating.Count (capitalising the C of count)
Which then errors with "Object doesn't support this property or method".
Is there a way to prevent Excel from deciding that .count is to use the inbuilt Count property, but is in fact the field name? I've tried many different ideas of what I can do to make it believe it's a field, e.g. "count", [count] etc but it doesn't allow any of them.
Thanks!
