Faedien

I was, because of some error I was getting early in the process. Better design prevailed and I didn't need that anymore, but it was still hanging out for no reason. All solved, thanks!

Hello all, I've lurked around here for a while and learned a ton from everyone, but I can't see this issue anywhere. I've been running macros through Autoit for a while in a number of programs, but I'm having some issues with this one. Func RunMacro() Local $oExcel = _Excel_Open(False, False, False, False) ;Excel Program Local $oWorkbook = _Excel_BookOpen($oExcel, "C:/Equity Helper/Scripts/calendarmacros.xlsm", Default, Default, True) $oExcel.Run("calendarmacros.xlsm!Calendar") EndFunc When I run this bit of code everything works fine as long as the macro gets to finish. But the actual VBA calls two "Application.UserInput" fields, and if I cancel out of either the macro closes, and then AutoIt throws an error at-- $oExcel.(<---error throws here)Run("calendarmacros.xlsm!Calendar") I don't want to use autoit for the user inputs if possible, it's just easier to get the data I need for the inputs from within the VBA environment, but I'm afraid that's what's causing the problem.

Worked like a charm, thank you so much!

This is my first post, but I've gotten solutions from this forum hundreds of times. This community is amazing! I can't figure this one out though. I'm trying to open a specific file and see if a specific number (in this case "100044141") happens. I want to eventually have the program copy the row where that number appears and then put that row of data in another sheet. I can't get past this though. #include <Excel.au3> Local $oExcel = _Excel_Open() Local $sWorkbook = "c:\tmp\CALDB.xls" Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook, Default, Default, True) Local $loanplace = _Excel_RangeFind($oWorkbook, "100044141", Default, Default, Default, Default) This script sees this error below. I've tried looking elsewhere for solutions to this, and I've checked with error checking to make sure that $oExcel and $oWorkbook were in fact objects. That all checked out fine, so I'm not sure what else I need to tell the program. Thanks in advance!