Why i can't open other excel files when running a script accessing an excel

[ashly]

i have an autoit script to access A.xls like below

_ExcelBookOpen("A.xls")

no matter invisibly or visibly with the flag, if i open other files (B.xls, C.xls...) then the script will crash

is it a known issue or i have done something wrong?

[water]

Any Error messages?

[ashly]

it seems like only happen when reading the value from cells

if i only open an excel and do nothing then i could open any other files i want

then i found other guys can run my script and open other files successfully

why??? is there any setting i need to modify for my computer?

my simple scripts:

#include <Excel.au3>

$oExcel_DM = _ExcelBookOpen(@ScriptDir &amp; "Result.xls", 0)

$iCol_DM = $oExcel_DM.Cells.SpecialCells($xlCellTypeLastCell).Column

$iRow_DM = $oExcel_DM.Cells.SpecialCells($xlCellTypeLastCell).Row

For $i = 1 To $iCol_DM

For $j = 1 To $iRow_DM

;MsgBox(0, "", $i &amp; "," &amp; $j)

_ExcelReadCell($oExcel_DM, $j, $i)

Next

Next

_ExcelBookClose($oExcel_DM, 0)

the error message is like below:

AutoIt3IncludeExcel.au3 (694) : ==> The requested action with this object has failed.:

Return $oExcel.Activesheet.Cells($sRangeOrRow, $iColumn).Value

Return $oExcel.Activesheet.Cells($sRangeOrRow, $iColumn)^ ERROR

open defferent excel will cause different error

AutoIt3IncludeExcel.au3 (194) : ==> Error in expressi&#111;n.:

For $i = 1 To .ActiveWorkbook.Sheets.Count

For $i = 1 To .ActiveWorkbook^ ERROR

Edited January 16, 2013 by ashly

[water]

Do you manually edit the workbook while the script is running?

[ashly]

I just double click to open other excel then the script crashed.

[water]

I can recreate this behaviour.

The problem might be caused by the UDF working with the activeworkbook/activeworksheet only. When you open another xls file during processing the activeworkbook/activeworksheet changes and hence the script crashes.

You can avoid the problem by starting a second instance of Excel and then opening the second workbook.

[CoolDude69]

Hi Guys,

I don't get an error, however the issue that I have when exporting to Excel is that if I open an Excel document the script writes to the file that was opened.

If I open a new Excel document the script continues without an issue.

Running on Win XP Pro SP3 with Office 2010.

Edited March 4, 2013 by CoolDude69

[JLogan3o13]

CoolDude69, since your issue is not the same, rather than hijacking the thread why not create your own, with a descriptive title and explanation of what you're trying to accomplish. I promise you will receive support more quickly that way.

[CoolDude69]

CoolDude69, since your issue is not the same, rather than hijacking the thread why not create your own, with a descriptive title and explanation of what you're trying to accomplish. I promise you will receive support more quickly that way.

Hi JLogan,

I have the same problem only I don't get an error; I cannot Run Excel when exporting with AutoIT. The application crashes, this is why I used this thread. I do apologize I did not want to hijack the thread.