External db files to Excel, via VBA automation ??
Hi. I'm currently doing a project on simulation using ProModel and i need to export the data files which are in (*.idb) format to Excel spreadsheets. The classical method is the normal "cut and paste", however i'm required to automate this export procedure using VBA. Are there any specific codes that is able to export the (*idb) format( or any other external database formats) to Excel by using VBA?
Really hope someone can help me in this.