Excel to VBE

Excel Property Resulting VBE Item

Application.VBE VBE object

Workbook.VBProject

VBProject object

Workbook.CodeName

The name of the workbook-level VBComponent in the workbook's

VBProject, usually "ThisWorkbook" in English versions of Excel 2007

Worksheet.CodeName

The name of the sheet-level VBComponent in the workbook''s

VBProject, usually "Sheetl", "Chartl", and so forth in English

versions of Excel 2007

0 0

Post a comment