Excel macro conversion

[Marc Vanzegbroeck]

Hi,

I want to create a macro from FW in excel.

I found this sample in VB

Code: Select all | Expand

*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

oExcel = CREATEOBJECT( "Excel.Application" )
oWorkbook = oExcel:WorkBooks:Add()
vbp = oExcel:ActiveWorkbook:VBProject