I am making a small tool with VBA, and need to view the sheetformat file(*.slddrt) and get its information, however, as my API level , it would open the .slddrt file 1 by 1 and then get the info, the performance is very bad.

I am wondering if we can use the VBA with document manager API to mak it ? Using document manger API , it can get the file information without running the SW , the performance is good.

questions:

1. can VBA use the document manager API ? need the key or not ?

2. yes in Q1, then can the ducument manager API view the file informatin of a sheet format file(.slddrt)

many thanks

regards

Vincent