Get List of Open Books

[plans]

Hello,

After a right click on a Tab at the bottom, where the sheets are displayed, I am selecting "Move or Copy...."; from there I am getting the "Move or Copy" window which has the drop down called "To book:".
When I click on the Drop Down Arrow, it displays a list of all open workbooks.

I am wondering how I could get a list of those workbooks including their extension names (let's say to be listed in the active worksheet column A, starting on A1.

Could you please advise?
Thanks

[BadlySpelledBuoy]

Perhaps something like this?

Please Login or Register  to view this content.

BSB

[plans]

Thank you BadlySpelledBuoy!

[BadlySpelledBuoy]

Happy to help

BSB