<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[Серый форум &mdash; AHK: Вставка найденной информации в эксель]]></title>
	<link rel="self" href="https://forum.script-coding.com/extern.php?action=feed&amp;tid=13640&amp;type=atom" />
	<updated>2018-04-23T18:47:17Z</updated>
	<generator>PunBB</generator>
	<id>https://forum.script-coding.com/viewtopic.php?id=13640</id>
		<entry>
			<title type="html"><![CDATA[Re: AHK: Вставка найденной информации в эксель]]></title>
			<link rel="alternate" href="https://forum.script-coding.com/viewtopic.php?pid=124856#p124856" />
			<content type="html"><![CDATA[<p>Я бы автоматизировал через WinHttpRequest.</p>]]></content>
			<author>
				<name><![CDATA[Malcev]]></name>
				<uri>https://forum.script-coding.com/profile.php?id=26930</uri>
			</author>
			<updated>2018-04-23T18:47:17Z</updated>
			<id>https://forum.script-coding.com/viewtopic.php?pid=124856#p124856</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: AHK: Вставка найденной информации в эксель]]></title>
			<link rel="alternate" href="https://forum.script-coding.com/viewtopic.php?pid=124852#p124852" />
			<content type="html"><![CDATA[<p>В файл CSV не проще заносить данные с веб страниц.<br /> <a href="https://wiki.imacros.net/Data_Extraction#Data_Extraction_and_Web_Scraping">https://wiki.imacros.net/Data_Extractio … b_Scraping</a>.</p>]]></content>
			<author>
				<name><![CDATA[svoboden]]></name>
				<uri>https://forum.script-coding.com/profile.php?id=34280</uri>
			</author>
			<updated>2018-04-23T01:48:59Z</updated>
			<id>https://forum.script-coding.com/viewtopic.php?pid=124852#p124852</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[AHK: Вставка найденной информации в эксель]]></title>
			<link rel="alternate" href="https://forum.script-coding.com/viewtopic.php?pid=124825#p124825" />
			<content type="html"><![CDATA[<p>Копирование из excel в ie и найденную информацию необходио скопировать обратно в соседний столбец.&nbsp; <a href="https://ibb.co/hiBgWn">https://ibb.co/hiBgWn</a></p><br /><div class="codebox"><pre><code>SetWorkingDir %A_ScriptDir%  ; Ensures a consistent starting directory.

$^1::
Setkeydelay, 35

FileSelectFile, Path, 3, , Open Excel File, Excel File (*.xls; *.xlsx)
if Path =
	ExitApp
Xl := ComObjCreate(&quot;Excel.Application&quot;)
Xl.Workbooks.Open(Path) ;open an existing file
Xl.Visible := True
if Errorlevel
{
	MsgBox, % &quot;Error opening excel file! Exiting...&quot;
	ExitApp
}

Sheet_Titles =
global Sheet_To_Calculate := 0 
loop, % xl.Sheets.Count
	Sheet_Titles .= A_Index . &quot;: &quot; . xl.Sheets(A_Index).Name . &quot;`n&quot;
While Sheet_To_Calculate &lt; 1 || Sheet_To_Calculate &gt; xl.Sheets.Count || !IF_Integer(Sheet_To_Calculate)
	inputbox, Sheet_To_Calculate, % Xl.ActiveWorkbook.Name, %Sheet_Titles%, , , , , , , , 1
if ErrorLevel
	ExitApp

global Current_Row := -1
While Current_Row &lt; 1 || !IF_Integer(Current_Row)
	inputbox, Current_Row, % Xl.ActiveWorkbook.Name, % &quot;Enter the row to start on.&quot;, , , , , , , , 2
if ErrorLevel
	ExitApp


while Xl.Sheets(Sheet_To_Calculate).Range(&quot;B&quot; . Current_Row).Value != &quot;&quot;
{
	
B_stored := Xl.Sheets(Sheet_To_Calculate).Range(&quot;B&quot; . Current_Row).Value
	
	
	
ControlFocus,, ahk_class IEFrame
Sleep 550
	
	
Click, 205, 285, 2
Sleep 150
Send %B_stored%
send {enter}
Sleep 2000
		
; Move to the next row
	Current_Row++
}

MsgBox, % &quot;Done! :)&quot;
ExitApp

IF_Integer(check_this)
{
	if check_this is not integer
		return false
	else
		return true
}

return</code></pre></div>]]></content>
			<author>
				<name><![CDATA[inseption86]]></name>
				<uri>https://forum.script-coding.com/profile.php?id=38818</uri>
			</author>
			<updated>2018-04-20T13:14:12Z</updated>
			<id>https://forum.script-coding.com/viewtopic.php?pid=124825#p124825</id>
		</entry>
</feed>
