I want to create a macro from FW in excel.
I found this sample in VB
- Code: Select all Expand view
- *Dim vbp As Object
Dim newmod As Object
Set vbp = ActiveWorkbook.VBProject
Set newmod = vbp.VBComponents.Add(1)
I try to convert in into FWH but have a problem already with the first line. I always get an error with VBProject
- Code: Select all Expand view
oExcel = CREATEOBJECT( "Excel.Application" )
oWorkbook = oExcel:WorkBooks:Add()
vbp = oExcel:ActiveWorkbook:VBProject