Comments (5)
Related to VBA-tools/VBA-JSON#111
from vba-dictionary.
I'm also noticing this error with the dictionary only on 64 bit versions. The read seems to work ok the first time but fails on subsequent reads. This is also quite variable as to whether it fails or not - doesn't seem to be any discernible pattern. My temp fix is to read the value only once.
from vba-dictionary.
Hi,
On 64 bits excel when i try to read a value like that LastName = Item("subscriber")("lastName")
I received a message : Automation Error
from vba-dictionary.
same problem here.
quick update:
the problem only occurs on accessing nested items - tested for 2 levels like Item("subscriber")("lastName")
Sometimes though it works. When it does not it works for now to assign a variable tmp to Item("subscriber") and then access from that variable tmp("lastName")
from vba-dictionary.
from vba-dictionary.
Related Issues (20)
- Support for Microsoft Office 2016 on MacOS HOT 2
- Default item function not working HOT 1
- Runtime
- Can not access the key or item using index
- How to use the added items in the collection into the dictionary HOT 1
- Empty .Items returns array of type Variant/String HOT 3
- Exception with key declared as string and modified in sub byref as variant
- Could you please specify how to use it? HOT 1
- Out of memory
- Syntax Error in property Get Count() HOT 1
- Removing an object key shifts values of all object keys added after it HOT 1
- Syntax Error
- throws Compile Error: sub or Function not defined
- Parse a JSON string to VBA-Dictionary HOT 1
- how to create a json request with child nodes
- second dictionary object is empty. HOT 2
- Not working for Excel 2021 HOT 3
- Run-time error '424' Object required HOT 6
- Run-Time Error '438' - Object doesn't support this property or method HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from vba-dictionary.