Excel macro conversion
Posted: Mon Apr 11, 2022 1:52 pm
Hi,
I want to create a macro from FW in excel.
I found this sample in VB
I try to convert in into FWH but have a problem already with the first line. I always get an error with VBProject
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