_IENavigate() How to get it to Navigate to a URL pasted in my Clipboard

[Skruge]

$flvfile = ControlGetText("Save As", "", "ClassNameNN=Edit1")

This is the Variable I used. Is it correct?

Close. Try

$flvfile = ControlGetText("Save As", "", "Edit1")

[tradertt]

Thanks figured out a way to do it hehe

expandcollapse popup

#include <IE.au3>

Opt("WinWaitDelay", 100)
Opt("WinTitleMatchMode", 4)
Opt("WinDetectHiddenText", 1)
Opt("MouseCoordMode", 0)

WinWait("Microsoft Excel", "")
If Not WinActive("Microsoft Excel", "") Then _
        WinActivate("Microsoft Excel", "")
WinWaitActive("Microsoft Excel", "")
Send("{CTRLDOWN}c{CTRLUP}")

$sURL = ClipGet()
$oIE = _IECreate($sURL, 0, 1, 0)
$hwnd = _IEPropertyGet($oIE, "hwnd")
WinSetState($hwnd, "", @SW_MAXIMIZE)
WinActivate($hwnd, "")
_IELoadWait($oIE)
_IELinkClickByText($oIE, "Download")
WinWaitActive("File Download")
Sleep (1000)
ControlClick ( "File Download", "&Save", "Button2")
WinWait("Microsoft Excel", "")
If Not WinActive("Microsoft Excel", "") Then _
        WinActivate("Microsoft Excel", "")
WinWaitActive("Microsoft Excel", "")
Send("{RIGHT}{CTRLDOWN}c{CTRLUP}")
WinActivate("Save As", "")
WinWait("Save As", "")
If Not WinActive("Save As", "") Then _
        WinActivate("Save As", "")
WinWaitActive("Save As", "")
Sleep(1000)
Send("{CTRLDOWN}v{CTRLUP}")
ControlClick ( "Save As", "&Save", "Button2")
Sleep(2000)
WinClose ($hwnd, "" )
WinWait("Microsoft Excel","Worksheet Menu Bar")
If Not WinActive("Microsoft Excel - test.xls","Worksheet Menu Bar") Then WinActivate("Microsoft Excel - test.xls","Worksheet Menu Bar")
WinWaitActive("Microsoft Excel - test.xls","Worksheet Menu Bar")
Send("{LEFT}{DOWN}")

Anyway how can I make it loop through the whole excel spreadsheet till it comes to a blank cell

[tradertt]

Does anyone know how to loop through all the things in excel?

[DaleHohm]

Suggest you open a new thread.

Dale