electrico Posted October 31, 2010 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
BugFix Posted October 31, 2010 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
electrico Posted December 21, 2010 Author 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)
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