Excel Automation - Command Buttons (control macros)

[tcb]

I would like to create an Excel workbook with command buttons (AKA
control macros). I have code to create a workbook. Now I need to
know how to create Excel command buttons, then set properties and
assign macros to the command buttons in VBA from Access. The code on
the button would generally be simple like this:

Private Sub CommandButton1_Click()

Sheets("Tab One").Select

End Sub

 

[Dennis]

This is not an Excel newsgroup. Please post your question in the appropriate
forum.

 

[tcb]

This is not an Excel newsgroup. Please post your question in the appropriate
forum.

However, I want to create the Excel workbook from Access.

 

[Alok]

However, I want to create theExcelworkbook fromAccess.

Hi

You could try code such as the following.

Sheet1.Shapes.AddOLEObject classType:="Forms.CommandButton.1"

Alok