Sorry Roger, but you'll need to go through a few extra steps (exporting, as you mentioned) instead of copying/pasting a single value. Still, it shouldn't be too onerous, especially as you only want a single value.
I'll assume that your VBA is with Excel.
I'd go so far as to create a special model file for this purpose. In the table, hide all of the other unwanted fields. If you're using a filter to isolate your value, save the model with the filter active. Finally, turn off the option to export the field names as the first row of output.
That way you'll have your have in A1 in the exported worksheet every time.
Now, as you're exporting the file programmatically, you'll always know the name of your exported xls workbook, so as soon as you're done with the Monarch processing, open the exported workbook, copy the value from A1 to where you want it, and close the exported workbook.
Workbooks("Programmed Workbook").Worksheets("Sheet1").Range("B3").value = Workbooks("Exported Workbook)").Worksheets("Sheet1").Range("A1").value
Will that work for you?
If you are more familiar with Access, you can go ahead and do you scripting in Acess. The only limitation is that you cannot export out of Monarch into the Access database or Excel spreadsheet you currently have open and running. You have to export out to a temp file somewhere and then import it into your db.
I primarily set up my scripts in Excel like Kruncher but I also have some set up in Access. If I need the data I just exported out into my Access db, I'll set up a macro or query to import it after Monarch closes.