All Forums  Origin Forum for Programming  Forum for Automation Server/COM and LabVIEW  Inconsistent bug with selecting worksheet

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by ChemistryGuy[/i] [br]Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2020b (64-bit) Operating System: Windows 10 I recently upgraded from 2020 to 2020b. I tried to run one of my Excel Macros that automates Origin and Excel crashed. After debugging I found that the line which crashed Excel was the second line below. These were the first lines in my macro that communicated with Origin. Set wbk = app.WorksheetPages.Add Set Wks = wbk.Layers(0) I then added the following line of code, and this fixed the issue. Set wbk = app.WorksheetPages.Add LayerCount = wbk.Layers.Count Set Wks = wbk.Layers(0) I tried to make an example VBA project to illustrate this, however when I did this, there was no problem. This is why I describe the bug as inconsistent. I just thought I should mention this here in case my workaround helps anyone, and also to let the developers know about the issue. [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.