sgebbie

I want to close any currently open Excel documents and save any that have not yet been saved. I couldn't get the _ExcelBookSaveAs to work when I was messing with those commands so I was trying to do it this way instead since I had it working with Word already. I was wondering the same thing about only closing the open workbook but it doesn't appear that any of the workbooks are actually closing either. Everything just seems to stop right there.

That makes sense as to avoid the loop but why would it not even attempt to close in the first place? With my Word process at the beginning I would assume that if the control click failed the same thing would end up happening there as well. Though with my current testing it does work, then hangs on the Excel part. Your suggestion will help to make sure I don't get stuck in an indefinite loop, but do you know why the Word function can "get" an inactive Word window but the Excel function can't? That's where I'm failing to see where the problem is or how to create a workaround for that. I did try this piece of code at first in the Excel function thinking it should work the same way it did in my Word function but it failed. I also read in the help file that this piece of code will only work if Excel is "activated" which doesn't really make sense to me. How does this piece of code really do anything at all if Excel has to be active first? Isn't that what that particular piece of code is doing anyway? "Getting" the existing Excel document? It seems to me that once it actually "gets" the object, I can continue on and manipulate it how I would like. Frustrating that it went so smooth with Word but Excel is being rather difficult. ; Get an existing Excel Object - but doesn't seem to work if it's not already active??? $oExcel = ObjGet("", "Excel.application") ; Get an existing Word Document - works and gets a non active Word document $oWordApp = ObjGet("", "Word.application") Basically this is not even getting far enough to get stuck in an indefinite loop. Is there any way that I can "get" an existing Excel document that is not active without using WinActivate? I trying to make this able to run behind a locked screen and I've read several different places that WinActivate will not work behind a locked screen.

Thanks anyway for the suggestion. I suppose I will have at it again...joy

Why does that work with my code for Word but not Excel? It's set up the same way and works fine in the Word section of the code. The While should only be true until the other functions close all of the currently open Excel windows but the close part never starts to happen with Excel for some reason.

I checked and there is definitely an EXCEL.EXE process running. I have several Excel windows open and minimized for testing and the process is there as well. I was reading something a little bit ago in another thread about using an #include <ExcelCOM_UDF.au3> and not needing to define the _ExcelBookSaveAs() I'm not using that particular command but would this work the same for not needing to define _ExcelBookClose()? I tried adding that to the beginning of my script but am getting an error opening the file? I'm not sure if I'm using that correctly. I'm only a little bit familiar with the #include commands but haven't seen it used like that yet. The only ones I've used or seen used are the ones that I'm using now #include "Word.au3" and #include "Excel.au3"

Would someone please be able to offer some assistance with this? I'm not sure what I'm doing wrong here.

I've been messing with this trying different methods for a week or so now and I'm stumped with how to get this to work correctly. I've managed to get the same feature to work correctly with word, though the commands to do the same with Excel seem a bit different. Below is the code I'm working with for this. Basically the script will pass through the Word function correctly without any errors and will hang on the Excel function. I threw in a command prompt in the Excel function to be sure the script was at least getting that far. It seems it gets to that point and then hangs. (The WinActivate("AutoIT v3")line I threw in the Excel function as well after reading another thread on a similar issue. Script still hangs with or without that added) http://www.autoitscript.com/forum/index.php?showtopic=21069 #include "Word.Au3" #include "Excel.Au3" If ProcessExists("WINWORD.EXE") Then Word() If Not ProcessExists("WINWORD.EXE") Then Excel() Func Word() Opt("WinTitleMatchMode", 2) ;Winword exists $oWordApp = ObjGet("", "Word.application") _WordQuit ($oWordApp) While ProcessExists("WINWORD.EXE") WinWait("Microsoft Office Word") ControlClick("Microsoft Office Word", "", "[ID:6]") Sleep(2000) ControlSend("Save As", "", "", "{ENTER}") Sleep(2000) WEnd Excel() EndFunc Func Excel() Opt("WinTitleMatchMode", 2) ;Excel exists Run("C:\Windows\System32\CMD.EXE") WinActivate("AutoIT v3") $oExcel = ObjGet("", "Excel.application") _ExcelBookClose ($oExcel) While ProcessExists("EXCEL.EXE") WinWait("Microsoft Office Excel") ControlClick("Microsoft Office Excel", "", "[ID:6]") Sleep(2000) ControlSend("Save As", "", "", "{ENTER}") Sleep(2000) WEnd Exit EndFunc I have played around with lots of other commands in testing. I'm also not too sure which commands will or will not work with hidden windows. I read in another thread that using WinClose() would work, although when testing I could only get it to work if I made the Excel window active first. Any help with this would be much appreciated.

Ideally when the script starts there is say a 50/50 chance that word will be running. If it is, it will be one of these scenarios. Word is running with a new document that isn't saved, word is running and it's just a blank unsaved document, or an existing document is open and changes have or haven't been made. So far I think what I have covers what I want to have happen? Seems to work ok during testing at least. Honestly with #5 I used _WordQuit because it performed what I needed it to oppose to using _WordDocSave when I was testing some commands out. I am still not entirely sure how to use the _WordDocSave command without actually opening a Word document first. All the examples I was able to find tied into opening the document first then doing a save or save / close based on that original document that was opened. All I will ever need to do with this script is save documents that are already open or already exist and have been changed. I shouldn't ever need to actually open anything. _WordQuit worked since it still prompts to save if the document already exists and has been changed or if it's a new document that hasn't yet been saved. If it's blank or an existing document that hasn't changed it just closes out which works for me. Is there parts of this that can be eliminated? I didn't look too closely at this since it was working for the most part. Any suggestions for cleaning things up a bit would be greatly appreciated. I am just starting into the Excel section and I've noticed that a lot of the Excel commands are different from Word so that's my next task is figuring out how to do the same thing with a different MS Office Program. This will all eventually tie into one large script. Just taking it one step at a time rather than trying to debug one huge script. Easier for me to debug pieces and then tie them in to the main script.

Thank you for the code edit. Things are starting to make a lot more sense. If I had a second function similar to the one shown here for say Excel. The #include "Excel.Au3" can go right above or below the Word #include correct? Do they have to follow any certain order? Word.Au3 first if that happens first in the script? Or is it not that specific?

So for any includes that I want to use they should go at the beginning of the main script? I'm guessing that since it's at the beginning of the main script it would still work correctly if this section is say..a sub section of the main script? Like making it a Func as I'm trying to do? If I'm using both a Word.Au3 and an Excel.Au3 both would go to the top of the main script?

Sorry it's confusing, i'm pretty new to code so it's probably a bit hard to decipher why I would do some things this way for some of you that are advanced coders. Only about my first week or so using AutoIT or coding anything really.. Just using what I've been able to figure out so far between the Help file, the boards and some questions I've posted on here. Basically my goal is for the script to check for the WINWORD.exe process and if found move to the next stage which is the part I posted the code for. In this step, I want to save and close only currently open word documents and then exit back to the main script once that part has completed. I have it somewhat working now and it's not looping. I'm stuck on the Func part since I need this piece of code somewhat seperate from the main script. The post above has the code and the error after attempting to make this piece a Func Hope I'm making some sense with this has been a lot to take in

Thanks for the responses. I was messing with it a minute ago and was able to get past that part. I forgot about the WinExist. That's exactly what I was looking to do and ended up getting around it like this before I read your post. #include "Word.Au3" $oWordApp = ObjGet("", "Word.application") _WordQuit ($oWordApp) While ProcessExists("WINWORD.EXE") WinWait("Microsoft Office Word") ControlClick("Microsoft Office Word", "", "[ID:6]") Sleep(2000) ControlSend("Save As", "", "", "{ENTER}") Sleep(2000) WEnd EndFunc This stopped the loop. I'm having some trouble turning this section of code into a function though. I get this kind of an error if i turn it into a Function like this. If ProcessExists("WINWORD.EXE") Then Word() ;Winword exists Func Word() #include "Word.Au3" $oWordApp = ObjGet("", "Word.application") _WordQuit ($oWordApp) While ProcessExists("WINWORD.EXE") WinWait("Microsoft Office Word") ControlClick("Microsoft Office Word", "", "[ID:6]") Sleep(2000) ControlSend("Save As", "", "", "{ENTER}") Sleep(2000) WEnd EndFunc Exit This is what it gives me when trying to make it a Func Line 85 (File "C:\Program Files\AutoIt3\Include\Word.Au3"): Func _WordCreate($s_FilePath= "", $f_tryAttach=0, $f_visible = 1, $f_takeFocus = 1) Error: "Func" statement has no matching "EndFunc". It looks like this is a result of an incorrect usage of the #include Word.Au3?

Script seems to get stuck in the While loop. It's working as designed, although I'm pretty sure I've got something wrong in the While loop. Could someone have a look and point me in the right direction as to what I might have messed up here? Also, will a WinWait command work on a locked computer? I can test it out if necessary but if someone knows that off the top of their head please let me know. ;Winword exists #include "Word.Au3" $oWordApp = ObjGet("", "Word.application") _WordQuit ($oWordApp) While WinWait("Microsoft Office Word") ControlClick("Microsoft Office Word", "", "[ID:6]") Sleep(2000) ControlSend("Save As", "", "", "{ENTER}") WEnd Exit I'd also like to make this particular piece a function of a larger script. Is there anything special I need to do for that aside from the Func() and EndFunc? I tried this earlier and it was complaining constantly about no EndFunc. EndFunc was there but it still wasn't working for some reason.

I think I'm starting to get some of this finally. So this starts with WinList() without an additional specification here --> () and as you said returns the array of All windows. Next the For... to ... Next - It looks to me like this part is using the For $i = 1 to $var[0][0] to use the $i variable for the count, starting the initial variable value of $i to 1, then using $var[0][0] as the number of windows returned and the For loop will end once it reaches the stop threshold which should equal the $var[0][0] which is the total number of windows generated by the array from WinList? Am I on the right track now? If that's not correct can you please tell me where I'm off? Thanks for your continued help with this.

Ahhh that makes plenty of sense. Thanks for that. Can you by chance explain this piece of code in really simple terms? I'm having some trouble understanding what does what. I understand parts and other parts I'm complely lost as to what it's actually doing. This might help me understand other things a little better as well. $var = WinList() For $i = 1 to $var[0][0] ; Only display visble windows that have a title If $var[$i][0] <> "" AND IsVisible($var[$i][1]) Then MsgBox(0, "Details", "Title=" & $var[$i][0] & @LF & "Handle=" & $var[$i][1]) EndIf Next Func IsVisible($handle) If BitAnd( WinGetState($handle), 2 ) Then Return 1 Else Return 0 EndIf EndFunc I understand the basics with comment boxes, variables, Func, some of the If statements, and parts of the message box. Mostly the words such as Details,Title and Handle. The code inbetween has me a little lost as to why this or that works and what makes it work. Hopefully if you can break this piece down for me it will make the other stuff I'm trying to learn make more sense.