#77 Office 365 Excel 2013 WindowsState error - won't tile sheets

[Kevin Stewart]

I have Office 365 with Excel 2013 (15.0). When running either of the compare add-ins results in:

Error 1004 (Unable to set the WindowsState property of the Window class) in procedure TileWindows of Module mdlMain
**
The problem seems to occur in cmdAlignVertical_Click when it hits the Window1.Top = 0** line.

After the error, the Sync Scroll window appears and the compare works even though the windows are not shown side-by-side.

Clicking on the Horiz button results in Unable to set the Top property of the Windows class.

The compare also seems to run very slowly, taking several minutes to do a simple screen of cells containing text only.

[Kevin Stewart]

Commenting out cmdAlignVertical_Click in sync seems to allow it to run.

There seems to be a problem now that Excel has multiple instances rather than having multiple windows within a single instance of the program.

[SteveT]

Maybe a difference with Excel 2013. I have 2010, so cannot confirm it.

Add the following line before Window1.Top = 0 line:

Window1.WindowState = xlNormal

and see if that helps.

[Kevin Stewart]

Thanks for the suggestion. I thought that I would try to replicate the fault before I made your suggested change but for some reason I cannot get the same failure today. I have other VBA that I run in some other spreadsheets and wondered whether that was causing the problem. I ran opened those workbooks and they didn't seem to cause the problem.

So at the moment all is working correctly.

I had the problem also occur on another PC so I'll try it there and see what happens.

[SteveT]

I read on the support forums about that error occurring when the Workbook is not in Normal mode (i.e. is minimised/maximised) and that sounded like it matched you situation when Excel is opening two instances of Excel with one WB in each vs. both open in one Excel instance.

On Thursday, December 3, 2015 9:58 AM, Kevin Stewart <kstewart99@users.sf.net> wrote:

Thanks for the suggestion. I thought that I would try to replicate the fault before I made your suggested change but for some reason I cannot get the same failure today. I have other VBA that I run in some other spreadsheets and wondered whether that was causing the problem. I ran opened those workbooks and they didn't seem to cause the problem.So at the moment all is working correctly.I had the problem also occur on another PC so I'll try it there and see what happens. [bugs:#77] Office 365 Excel 2013 WindowsState error - won't tile sheetsStatus: open
Group: Current_Version
Labels: Office 365 Error 1004 Sync
Created: Tue Dec 01, 2015 10:54 AM UTC by Kevin Stewart
Last Updated: Tue Dec 01, 2015 02:04 PM UTC
Owner: SteveTI have Office 365 with Excel 2013 (15.0). When running either of the compare add-ins results in:Error 1004 (Unable to set the WindowsState property of the Window class) in procedure TileWindows of Module mdlMain

The problem seems to occur in cmdAlignVertical_Click when it hits the Window1.Top = 0 line.After the error, the Sync Scroll window appears and the compare works even though the windows are not shown side-by-side.Clicking on the Horiz button results in Unable to set the Top property of the Windows class.The compare also seems to run very slowly, taking several minutes to do a simple screen of cells containing text only.Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/spreadshcompare/bugs/77/To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/