Dave10910

Oh DUH! Thanks for pointing that out.

Hi, I'm having some issues with _excel_rangecopypaste. No matter what I seem to do I can't get it to paste values instead of a formula. #include <MsgBoxConstants.au3> #include <Excel Rewrite3.au3> #AutoIt3Wrapper_run_debug_mode=Y Global $oAppl = _Excel_Open() Global $excel = _Excel_bookopen($oAppl, "C:\Users\' & @username & "\Desktop\TrackerTesting.xlsx") _Excel_RangeCopyPaste($excel.Worksheets("Mapped"), "M2", "Q2", True, Default,$xlPasteValues, True) Is there something I should be changing here? Thanks for your time.

Hello, If you go to the UPS tracking site(http://www.ups.com/tracking/tracking.html) and enter a tracking number you get to a page that has the tracking details. There are two (menus?) that collapse. One is called Additional Information and the other is called Shipment Progress. I have no problems manipulating the additional information menu, but after a number of tries I cannot get the Shipment progress menu to open up. Here is the code that I am using. Func _UPSTrackingSite() _IENavigate($bIE1, $UPSTrackingSite) $UPSTrackingBox = _IEGetObjByName($bIE1,"trackNums") _IEAction($UPSTrackingBox,"focus") _IEFormElementSetValue($UPSTrackingBox,$UpsTrackingNumber) _IELoadWait($bIE1,250,20000) $UPStrackingButton = _IEGetObjByName($bIE1, "track.x") _IEAction($UPStrackingButton,"focus") _IEAction($UPStrackingButton,"Click") _IELoadWait($bIE1,250,20000) $ShipprogButton = _IEGetObjByID($bIE1, "collapse3") _IEAction($ShipprogButton,"focus") _IEAction($ShipprogButton,"Click") _IELoadWait($bIE1,250,20000) EndFunc