I have been harvesting data from Acad drawings and dumping it into Excel for years now. Just when you think you've mastered the technique, something new comes up.
I have two versions of Excel installed, 2003 and 2007. The firm at large uses 2003. I have 2007 for evaluation and testing and I am developing an Acad VBA application that exports to Excel. I will need to distribute the application in 2003. My problem is, when I start Excel from VBA, I get 2007, not the 2003 I want.
Any ideas how I can force 2003 to start?Code:Dim XL As Excel.Application Set XL = CreateObject("Excel.Application")