Author Topic: Open excel file  (Read 10442 times)

0 Members and 1 Guest are viewing this topic.

Lee Mac

  • Seagull
  • Posts: 12922
  • London, England
Re: Open excel file
« Reply #15 on: October 13, 2011, 10:33:30 AM »
The Shell Object is part of Windows Shell - this interface provides a wealth of objects, properties and methods for manipulating file/folders and the Windows OS. Here is another example utilising the 'BrowseForFolder' method of the Shell Object.

"Excel.Application" is a ProgID (PROGrammatic IDentifier) for interfacing with the ActiveX (COM) Excel Application Object, as part of the Excel Object Model; (equivalent to (vlax-get-acad-object) to retrieve the AutoCAD Application Object as part of the AutoCAD Object Model). The Excel Application Object will have its own properties and methods, for manipulating objects in Excel. Here is an example by Terry Miller of using the Excel Application object to interface with Excel.
« Last Edit: October 13, 2011, 10:52:12 AM by Lee Mac »