Path for an excel embedded file

[florin]

Hello

 

I am using an excel file (as bill of materials) embedded in many dwg files (Autocad files). This file contains VBA code that export data in another excel file.

I export data from different autocad files to an xls file (on disk).

 

My problem is: I cannot extract the path for excel embedded files (excel VBA returns ""). I need this path when users work at different jobs with different dwg files in the same time.

 

Do you know how to extract the path (for excel embedded file or for dwg file that contain an embedded excel file) from excel VBA code?

 

At this moment I use a lisp routine (for Autocad) that returns the dwg file path when an dwg file is open, but there is a problem when I open another dwg file (returns a new path).

 

Thanks