You can't.

And you said writing to a file is not a solution.

The only workaround I can think of is @froadie's workaround to his own problem link, where he ended up changing his macro to write output to a particular cell within the workbook.