I am trying to do the following:
- A user will enter data in a single column in Excel then run an AutoIT script
The script will:
- Copy the data in that column to an array
- Combine the array data to a url prefix and load it in a browser ie. ( http://www.website.com/page.php?<data from cell1>)
I've been attempting this for a few hours now without success, and finally I am giving in and asking for your help.
Specifically I need to know how to:
copy the data to an array from excel
pull data from that array and loop a function that will:
1. open the url
2. perform other tasks I actually know how to program
and perform this loop until each item in the array has been used (ie. each url has loaded)
The data in column A will have a dynamic number of rows depending on how the user is editing the file.
Sadly all I have to show for myself is the following:
#include <IE.au3> #include <Array.au3> #include <Excel.au3> Local $sheet = @ScriptDir & "\file.xlsx" ; to be used later WinWaitActive("Microsoft Excel - file.xlsx")
Any help would be greatly appreciated.