vbscript to run excel marco

[redree]

hi everyone,
i'm trying to create o vbscript to run a macro in an opened workbook, i managed to create one but my problem in whenever i run the script the workbook get opened again even if it's already opened.
can you help so i can be able to do the following,
the workbook will be opened manual
when i run the script a macro will run and update the cell "A1" by adding "1" cell value will be "2", if i run the script again cell "A1" will be "3" next run "5"....
i don't need the script to save or close the workbook.
bellow is the script i am using at the moment.

Dim xlApp
Dim xlWkb

Set xlApp = CreateObject("excel.application")'
Set xlWkb = xlApp.Workbooks.open ("C:\Users\elife\Desktop\project.xlsm")
xlWkb.RunAutoMacros 1 'xlautoopen
xlApp.Run ("table1")
xlApp.Visible = True

Set xlWkb = Nothing
Set xlApp = Nothing

thank you

[jd16]

Please upload a workbook with a clear

explanation in the sheets itself by

highlighting the cells, rows or columns where

you want to get the help for with a remark if

needed.



Regards

[redree]

Dear

workbook uploaded

thanks

[redree]

no solution?? please help

[alansidman]

Welcome to the forum.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have added them for you this time. Please read our rules and adhere to them in the future.)

[redree]

Dear Alan
i am new in coding my code is saved in noetpade as VBS.

Regards

[redree]

please guy, have a look on this thread.