Can you return a value from an excel macro in LabView?

[mashman]

I need to search an excel spreadsheet for all occurrences of a certain
text string and then return the addresses (cells) of the data. I've
written a macro that can do the searching but I'm not sure if I can
return the cell addresses. I'm using the Application.Run method in
Labview and this method only takes arguments that are passed to the
macro but there is nothing for returning data.
Any ideas?
Thanks

[Lab Viewer]

A solution is to place the result inside an available cell (using your macro) and read its value within LabVIEW after calling ".run" method (the result may be a string containing cell names).

Hope this helps