Path to AutoCAD file containing Excel file

I have an embedded Excel file (.xls) in an AutoCAD file (.dwg). Using VBA (in Excel), I want to extract the path to the file that contains it (the path to the AutoCAD file).


source to share

1 answer

If Excel is embedded in an AutoCAD file, you will need an AutoCAD compatible API to read the host AutoCAD DWG file. Search here for the AutoCAD API, but there are mainly AutoCAD (surprise!) And the Open Design Alliance .

If you go to the embedded Excel file, then it doesn't know that it was embedded in anything, so it won't know that path to the host AutoCAD DWG file.



All Articles