Create Macro in excel via FW

Post Reply
Marc Vanzegbroeck
Posts: 1163
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Create Macro in excel via FW

Post 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
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
Posts: 1163
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium
Contact:

Re: Create Macro in excel via FW

Post by Marc Vanzegbroeck »

It seems not so easy to do :cry:
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
User avatar
Marc Venken
Posts: 1485
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: Create Macro in excel via FW

Post 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.
Marc Venken
Using: FWH 23.08 with Harbour
Post Reply