Get file name

[electrico 0]

Hi guys!!

I got a problem with working file identifying. Actually it is excel file and the purpose is to determine whole file name with path and extension, that is currently processing by excel.

Can you pleae write a small example to show me the right way of thinking?

Friendly yours, elect.

Edited October 31, 2010 by electrico

[BugFix 43]

Try this:

$oExcel = ObjGet('', 'Excel.Application')

; all WorkBooks
$colWorkBooks = $oExcel.Workbooks
For $WorkBook In $colWorkBooks
    ConsoleWrite($WorkBook.Path & '\' & $WorkBook.Name & @CRLF)
Next

; active WorkBook:
ConsoleWrite($oExcel.ActiveWorkbook.Path & '\' & $oExcel.ActiveWorkbook.Name & @CRLF)

Edited October 31, 2010 by BugFix

[electrico 0]

Magically. Thx a lot, but can you pm me or write a post here how did you got object extensions and classes? (kidna global queston)