Create a macro which open and run a macro in another workbook

Hello.

Considering that I do not have power automate desktop ( only cloud) I have to automate something via VBA.

Actions:

1) I have a workbook ( A ) with a sheet named "parameters' and in this sheet there is a list with parameters ( Fix , Floating , None ) . I have to select one of these values.

Build a macro in this workbook ( A) which does :


2) Open another workbook ( B),
3) Transfer in (B) in a precise cell the parameter selected in the workbook A
4) Run a macro already build in the workbook (B) which is going to use as the main parameter the one that we just transferred in (B) via action 3 .

4) At the end I'd like to transfer ( copy / paste) the output of the macro in the workbook (B) in another workbook ( C) .
5) Close workbook (B)

Is it possible ?

If I recall correctly the format is

Please Login or Register  to view this content.