electrico Posted October 31, 2010 Share Posted October 31, 2010 (edited) 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 Link to comment Share on other sites More sharing options...
BugFix Posted October 31, 2010 Share Posted October 31, 2010 (edited) 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 Best Regards BugFix Link to comment Share on other sites More sharing options...
electrico Posted December 21, 2010 Author Share Posted December 21, 2010 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) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now