Page 1 of 1

Create Macro in excel via FW

Posted: Wed Oct 13, 2021 1:01 pm
by Marc Vanzegbroeck
Hi,

Is it possible to create a macro via FW?

This is why.
1. I create an excel with data and functions via my program.
2. Than this file will be copy on another (process-control) computer.
3. Then some actions should be done,after opening the excel-file, before the excel can extract data from the system.

It would be nice that there is a macro included in the excel-file that must run 1 time, so I don't have to do those manual actions anymore

Re: Create Macro in excel via FW

Posted: Mon Oct 18, 2021 7:24 am
by Marc Vanzegbroeck
It seems not so easy to do :cry:

Re: Create Macro in excel via FW

Posted: Mon Oct 18, 2021 6:30 pm
by Marc Venken
Marc,

You could make a macro extension file and launch it before the actual exel file not ?

Maybe i'm not on the right track of what you need.