I'm stumbling along with following:
The idea is to get a list of all workbooks INCLUDING addins.

How do I get following (or any xl4 macro command) to return an array?


Function AllBooks() As Variant
Dim v
v = ExecuteExcel4Macro("Documents(3)")
Stop
End Function

For the moment I circumvent this by using a name object...
but I'm sure there must be a more elegant way of doing this.

keepITcool
amsterdam, holland