Hi,

I have a VBA application that needs to parse data from a string into a
worksheet. I have to consider optimised performance, since the
worksheet contains real-time data.

Is it advisable to keep the data as a Strings..and use the string
manipulation functions for search / find to get my key value pairs ?

OR

Should I create Objects that have the key-value pairs as properties to
set /get from?

Both of them being feasible solutions, which would give me a better
performance? I'm New to VBA and understand from my programming
experience, that both String and Object manipulation could prove heavy
(like in Java - everything is an object) . But not sure, how this is in
VBA's object oriented design.

Please help.

-Megha.