Create Macro in excel via FW

Create Macro in excel via FW

Postby Marc Vanzegbroeck » Wed Oct 13, 2021 1:01 pm

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: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

Re: Create Macro in excel via FW

Postby Marc Vanzegbroeck » Mon Oct 18, 2021 7:24 am

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

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

Re: Create Macro in excel via FW

Postby Marc Venken » Mon Oct 18, 2021 6:30 pm

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.04 with Harbour
User avatar
Marc Venken
 
Posts: 1426
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 83 guests