topic Batch export EXCEL OLE TO excel file in VBA Forum

Batch export EXCEL OLE TO excel file

likesela — Fri, 15 Sep 2023 10:36:30 GMT

I have lots cad file(.dwg) each incloud a BOM (excel ole), i need batch export each BOM(excel ole) to each excel file (same file name.XLSX), anyone can help me ? i can Donate, please

Re: Batch export EXCEL OLE TO excel file

Ed__Jobe — Fri, 15 Sep 2023 15:03:44 GMT

In your dwg, you can't use OLECONVERT. Your only option is to use OLEOPEN and then use Excel to SaveAs. Also, in VBA and lisp, there is no way to work with the ole in a silent method. You can only script the OLEOPEN command and that will open the ole in Excel. So in a batch mode, you would end up with a bunch of instances of Excel that you would have to save the file and close the app. In other words, batch processing gets messy.

In NET, it can give you access to the actual OLE object and then you can access Microsoft's api's. If you ask in the NET forum, someone might be able to help you.

Re: Batch export EXCEL OLE TO excel file

aurocherie3 — Mon, 25 Nov 2024 13:25:07 GMT

Hi, did you finally succeeded into batch export ?

I have the same need... (tried w/ python but no success for the moment...)

thanks