Hi, Is it possible to send a command/signal from excel (vba) to tell dynamo to start or to continue a script ? [Capture]

Seems like it would be best to create two separate graphs. You could run them from Dynamo Player that way.

[image] Nick_Boyts: run them from Dynamo Player Not totally sure it would work: [image] Revit Crashed with Open Excel Revit @jacob.small , my script reads some information from an excel file to create rebars from curves. Tried closing Dyhnamo Player and then saving …

You’d have to run the script from Dynamo Player, close Player, make changes and save, then run second script from Player. It’s not the most elegant method but I think it would still work. The image doesn’t show node names so I can’t tell what’s going on in the script, but it’s possible you could ke…

Just an idea also, you could maybe try to read a specific cell just before a Passthrough node (Clockwork). [image] How to read a specific cell from Excel? [image]

Thanks Yna. I just thought of that too. But dynamo has to keep watching my excel file for that specific cell to change. But it might work. I’ll let you know. Running a second script after changing and saving the excel file is something I want to prevent.

I love this idea…this would be amazing…control Dynamo for VBA! :grinning:

@erfajo This trick works well indeed :slightly_smiling_face: @d.kelfkens I did not manage to read a specific cell with ReadExcel.ByRange (I can not make it work anymore, I don’t know why) but I was looking for a solution to make the graph wait until I give an additional input and I succeeded with S…

Is it possible to make a python script detect an active workbook/sheet (not opening a new one) and check a certain cell value for a change (a switch 0/1) using a loop? After changing from 0 to 1 the script imports all data from the sheet.

I believe that excel nodes update every time the file is saved by something other than dynamo.

I noticed that. That is just what I’m trying to prevent. It has to update after I finished entering data.

Start dynamo script from excel

Developers

Yna_Db September 14, 2017, 6:48pm 3

Not totally sure it would work:

Topic		Replies	Views
Help with this easy dynamo. data.importexcel Uncategorized dynamo	14	656	November 14, 2019
How to create table in dynamo ? or How to write live excel table Revit dynamo	14	1569	January 13, 2023
Dynamo Logic, write and read from the same EXCEL file at the same time Uncategorized revit	7	4400	June 9, 2016
Is it possible to open Excel file, wait for user input, close Excel and then continue the graph? Uncategorized	3	489	April 16, 2019
Create sheets from excel file with dynamo Revit dynamo	1	481	December 26, 2019

Start dynamo script from excel

Related topics