object-model | : octopus : object-model is a tiny package that help | 3D Animation library

How can I get a complete list of references to each running Excel application instance (regardless of their amount of workbooks and visibility state)?

I know that I can use the Windows API to find each Excel workbook window (which has the window class name EXCEL7), get their handles to use with the AccessibleObjectFromWindow function, then dispatch and get the application COM object.

Though that only works with the Excel application instances that have at least one workbook visible. How can I also get the Excel application instances that are hidden and/or don't have workbooks?

The Excel application instance window (which has the window class name XLMAIN) doesn't retrieve any accessible object.

I'm looking for an explanation, with or without pseudocode, or code of any programming language, as long as I'm able to understand and implement it myself (in Python).

I am successfully modifying multiple Excel files using library(RDCOMClient). However, setting a cell value to a non-ascii string results in å becoming Ã¥ etc. I also cannot pass an UTF-8 filename to Excel's Open() and Save() methods. Hopefully there is a single solution to both problems.

Here's a simple reproducible example using Save(): Creating an empty workbook and trying to save it as å.xlsx results in Ã¥.xlsx. The same operation works fine for a.xlsx.

I'm attempting to use Autodesk Inventor's COM API to create a python script that will generate PDFs of a selection on Inventor Drawings, these PDFs will then be processed in particular ways that aren't important to my question. I'm using pywin32 to access the COM API, but I'm not particularly familiar with how COM APIs are used, and the pywin32 module.

This is the extent of the documentation for Inventor's API that I have been able to find (diagram of API Object Model Reference Document), and I have not been able to find documentation for the individual objects listed. As such, I'm basing my understanding of the use of these objects on what I can find from examples online (all in VB or iLogic - Inventor's own simple built-in language).

A big issue I'm coming up against is in creating the objects I'd like to use. Simplified example below:

I searched documentation Office Excel API, but cannot find any mentions at all, how it can be implemented.

The Problem:

Luck of API functionality or some sort of bugs can be solved easily by VBA macros.

But, for doing that, we have only two possibilities:

1. Insert macro manually into sheet, which will catch some event on sheet, and JS from addin will trigger that event (this solution came from very old forum (if I will find the link, I will insert it here)).

2. Insert macro by JS code to sheet (context.workbook.worksheet?) during addin runtime, and even it cannot be executed by addin, but in this case the end user do not need to manage macro at all - we can make process of macro running more smooth with the same logic (JS inserts macro into sheet, change some value in sheet and then it triggers some macro, and after that (for example after some timeout in JS or just by another event in JS we can easily delete the whole sheet with this macro)).

So the question is, is it possible somehow make something similar to solution 2 using the Excel API? (some sort of function to insert/delete VBA code from addin)

I will appreciate any help!

Example to clarify problem

I'm using the JavaScript API, but unfortunately the API doesn't cover full functionally (I hope yet) which is already existed in VBA. Let me explain it on a simple example:

Imagine a task:

1. We need to copy some information from sheet 1 in workbook 1

2. then we need to create a book and just put the values in new workbook 2

3. then we need to suggest to user where it(new workbook 2) needs to be saved.

4. then we need save and close workbook 2.

VBA resolves the problem easily, but in case JS API - there is no full solution of this problem (without third-party applications).

You can compare API JS and VBA by follwoing links below:

Workbooks JS API

Workbooks VBA API

So what I want to do - is to write actual VBA macro in JavaScript and insert this VBA macro into sheet to make the macro executable.

How to make macro executable from some value change on sheet?

I found out that, if you call select method directly applying to cell and catch selection change using Worksheet_SelectionChange in VBA - it perfectly worked.

Unfortunately direct set values to cell doesn't trigger VBA Worksheet_change

Why am I using JS API

Currently I already have a VBA project for similar tasks, but as the project grow and evolve - some features here, some features here, I saw that addins - is the best solution to resolve key problems - its easier to maintain, manage, develop, push updates, install, and it just look better - because an addin is just one simple website

Update 2019/09/20 - Possible Workaround

First of all, great thanks to @DecimalTurn, who made this workaround possible. See his original answer below

I a little bit modify it and added additional JS script and VBA script to make this solution complete. So:

1. The following VBA macros needs to be inserted BEFORE you will make any actions from JS to ThisWorkbook module:

1.1. VBA macro which will handle all VBA code which we will transfer

I've been researching browser rendering and I've just now come to the part in the render process where the browser constructs the CSSOM from raw CSS.

In all of the tutorials I've seen the authors seem to make the assumption/assertion that the body element is the root, and that all styles applied to the body will tacitly be applied to the rest of the DOM unless explicitly overridden by another selector. An example of this is here https://blog.logrocket.com/how-css-works-parsing-painting-css-in-the-critical-rendering-path-b3ee290762d3/

and here https://developers.google.com/web/fundamentals/performance/critical-rendering-path/constructing-the-object-model

In both of these explanations- the body tag is assumed to be the root, even though the html tag seems like it should be the root. Whats more is the fact that the HTML specification doesn't seem to require EITHER of these tags in markup (maybe I'm misunderstanding this though).

To me this seems like an incredibly important piece of information when applying styles to elements in the render tree. If one does not know which element is the root, then one does not know how the styles should cascade onto one another.

So my question is essentially, do browsers always assume that the body element is the root, or is there a method for determining which element should be the root in the browser's CSS Tree?

I am looking to iterate through sentences/paragraphs within cells of a docx table, performing functions depending on their style tags using the pywin32 module.

I can manually select the cell using cell = table.Cell(Row = 1, Column =2)

I tried using something like

for x in cell:
#do something

but objects 'do not support enumeration'

I tried looking through: Word OM to find a solution but to no avail (I understand this is for VBA, but still can be very useful)

I'm trying to prepare end to end tests using the Page Object Model pattern. I write my tests in TypeScript, using Protractor.

I noticed that the first few lines of each test specification file looks very similar:

Looking at information at:

https://dev.office.com/sharepoint/docs/general-development/working-with-the-sharepoint-workflow-services-client-side-object-model

and

https://sharepoint.stackexchange.com/questions/159432/programmatically-create-workflow-with-javascript-jsom-and-sp-workflowservices-w

I am trying to create site workflow for Project Server 2016 - that means it's platform type had to be SharePoint 2013 Workflow - Project Server

Like in question on stackexchange, first i've created sample workflow from spd 2013, saved as template and retrived generated xaml to my xaml string.

I'm having a difficult time trying to get the below code to work in IE. The code works as expected in Firefox, Chrome, and Edge; but not in IE. I would ignore it not working in IE, but it's the default browser used at work.

The code is written to upload multiple files into a specific SharePoint document library. I got the code from this post https://social.msdn.microsoft.com/Forums/office/en-US/bb590f35-da1b-4905-baa0-fb85a275abf6/multiple-files-upload-in-document-library-using-javascript-object-model?forum=appsforsharepoint. It's the last post, and it does work great in the mentioned browsers. Any suggestions on how to get it to work in IE will greatly be appreciated. Thank you in advance.

Script is below: