VBA
Discuss AutoCAD ActiveX and VBA (Visual Basic for Applications) questions here.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Batch export EXCEL OLE TO excel file

2 REPLIES 2
Reply
Message 1 of 3
likesela
345 Views, 2 Replies

Batch export EXCEL OLE TO excel file

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

Tags (3)
2 REPLIES 2
Message 2 of 3
ed57gmc
in reply to: likesela

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.

Ed


Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
How to post your code.

EESignature

Message 3 of 3
aurocherie3
in reply to: likesela

Hi, did you finally succeeded into batch export ?

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

 

thanks

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

AutoCAD Inside the Factory


Autodesk Design & Make Report