How Do I Update Quicken 2017 from a Variety of Sources, including Apple Numbers?

[JMichaelTX]

@macroenthusiast

One copies fields from a list of transactions in a Numbers spreadsheet. The second macro, posted here, enters most of the transaction in Quicken.

History: My macros worked great for several months. I'm now having problems with copying and pasting.

Copy function (not uploaded)Have tried Command C, and copy functions. Not always reliable

It appears that the Apple Numbers app has some issues concerning the copy of cell data to the clipboard. See:

• Post by @ccstone
• AppleScripting Apple"s Numbers Spreadsheets

Some ideas:

1. Since both Numbers and Quicken support AppleScript, that might be the best solution.
2. Possibly export the Numbers data to file, then import to Quicken.