I have made macros that open Excel, Load Excel, Read Excel, Save Excel and make Sage 300 transactions and so on.

Has anyone ever put a Sage 300 macro into standalone Excel with a full interface with the API; is this even possible.

I know with a script I can force an AVB to start basically by invoking A4WVBA but never embedded a full API interface into a standalone Excel even if the station has Sage300 installed.

not sure if this is even possible.

Any info would be great - even if 'forget it' is the best advice.

thanks