I am the as beginner as they come to VB 6.0. My project is to control another program through CATIA DesignTables (parameterized Excel sheets that update a CATIA model) through a VB interface. So I need to select the sheet, modify and save/close all within VB.
I would like to access Excel worksheets from a TreeView type selection process and then view and modify these sheet within the same VB interface.
I have created a TreeView and have been playing around with the OLE Excel Worksheet function. Now I need to make it all work together, or maybe someone can explain a better way to do this.
If there are obvious limitations in my concept, please let me know!
Thanks for any input.
Matt
I would like to access Excel worksheets from a TreeView type selection process and then view and modify these sheet within the same VB interface.
I have created a TreeView and have been playing around with the OLE Excel Worksheet function. Now I need to make it all work together, or maybe someone can explain a better way to do this.
If there are obvious limitations in my concept, please let me know!
Thanks for any input.
Matt