Activate Excel - Not activating

[tauruzian]

I used this code to get the excel file name and activate the file:

#include <Excel.au3>

Global $oExcel = _Excel_Open()
Global $oWorkbook = $oExcel.ActiveWorkbook
WinActivate($oWorkbook.Name)
Global $sText = WinGetTitle("")
ClipPut($sText &"::" &$oWorkbook.Name)
MsgBox(0,"Test",$sText &"::" &$oWorkbook.Name)

Initially, the code working fine in Window 7 using Excel 2013. When I try to execute the same code in Window XP using Excel 2007, the workbook did not activated.

Above screen shot shows that the code managed to activate the excel and get the filename in Msgbox (Window 7 and Excel 2013).

Above screen shot shows that the Excel not activated but only show the filename on Msgbox (Window XP and Excel 2007).

Please advice.

[water]

With the new Excel UDF you need to call _Excel_Open to start Excel, then _Excel_BookOpen or _Excel_BookNew to open an existing/create a new workbook.

Automating the Excel GUI is a bad idea. There are COM properties to retrieve the information you need.

[tauruzian]

With the new Excel UDF you need to call _Excel_Open to start Excel, then _Excel_BookOpen or _Excel_BookNew to open an existing/create a new workbook.

Automating the Excel GUI is a bad idea. There are COM properties to retrieve the information you need.

How to activate the minimised Excel rather than open a new one.

[water]

Is Excel already running when you start your script?

[tauruzian]

Is Excel already running when you start your script?

Yes. But minimised by the user

[water]

Something like this?

#include <Excel.au3>
$oExcel = _Excel_Open()
$sCaption = $oExcel.Caption
WinSetState($sCaption, "", @SW_MAXIMIZE)

[tauruzian]

 

Something like this?

#include <Excel.au3>
$oExcel = _Excel_Open()
$sCaption = $oExcel.Caption
WinSetState($sCaption, "", @SW_MAXIMIZE)

The code working fine but fail in 1 condition. Let say I highlight some text the cell and minimised the excel and run the code. It does not working.

[water]

Do you mean edit or just select?

[tauruzian]

Do you mean edit or just select?

Just select or just click into the cell and minimised the excel. It not working for both (2007 and 2013).

[water]

When a cell is just selected it works fine (because at least a single cell is allways selected = the active cell).

When the cell is in edit mode then I haven't found a way to maximize the window and show thw workbook.

Is it possible to disable edit mode to solve this problem (can be done by the AutoIt script)?

[tauruzian]

When a cell is just selected it works fine (because at least a single cell is allways selected = the active cell).

When the cell is in edit mode then I haven't found a way to maximize the window and show thw workbook.

Is it possible to disable edit mode to solve this problem (can be done by the AutoIt script)?

Yes, how do I disable the edit mode?

[AnonymousX]

On 3/2/2015 at 3:32 AM, water said:

Something like this?

#include <Excel.au3>
$oExcel = _Excel_Open()
$sCaption = $oExcel.Caption
WinSetState($sCaption, "", @SW_MAXIMIZE)

Thanks Water, was trying to figure this out