Create macro in excel from VB application
Posted on 2001-08-13
I am trying to create a excel macro from VB.
In a VB application i create an excel sheet, workbook
I would very much like to create a macro. This could
fx. be a simple macro that sets the font size.
After saving the sheet (from VB), I would like to be able to see the macro in excel (alt-F8).
I can see that excel.application in VB has a Sub called MacroOptions, where it is possible to set the ShortCutKey.
There must be some way, to create the macro!?