FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Create Macro in excel via FW
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Create Macro in excel via FW
Posted: Wed Oct 13, 2021 01: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
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: Create Macro in excel via FW
Posted: Mon Oct 18, 2021 07:24 AM

It seems not so easy to do :cry:

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
Re: Create Macro in excel via FW
Posted: Mon Oct 18, 2021 06: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.08 with Harbour

Continue the discussion