I have an excel sheet "project.xl sm" with a macro "add" that update a cell value.
i want to run the macro using vbscript externally.
the important thing is i don't want to vbscript to open the workbook or close it as i will be openning and closing it manually, the vbscript should only run the macro.
any help please

i'm stuck in 3rd line
my file name is "project" and file path is "C:\Users\redre e\Desktop\proje ct1.xlsm"
how can i insert them i your code for testing
thank you for your help as i am very new in scripting.

I'm Looking for VBscript that will check to see if a specific Excel workbook is open and then run a macro, and in case if the workbook is close it will open the workbook.
i tried bellow code but it open the worbook as read only if the workbook is previously open.
when running the macro it will add 1 to cell F9, when running the macro via vbscript same workbook will open as read only and run the macro.
apreciate your help
...