How to Click a Command Button from another workbook

[Mark Elkjaer]

All

I am relatively proficient at Excel but somewhat new to VBA so please excuse my possibly poor terminology.

I have two separate workbooks 'A' and 'B' and I have written VBA code in workbook 'A' which successfully opens workbook 'B'. What I require is VBA code in workbook 'A' which will click/activate the Command Button in workbook 'B'. Or alternatively is there a means of automatically clicking/activating the Command Button in workbook 'B' when it is opened?

I have read several discussions on this topic in various forums but have not found a suitable solution.

Would appreciate any suggestions!

Thanks
Mark

[HaroonSid]

Upload sample files

[Mark Elkjaer]

haroon

I have not attached the sample files as they contain 'sensitive' information, hence I have just referred to the files as 'A' and 'B'.

[scottiex]

You should just strip out the sensitive data - or create a sample book that is similar.

But my guess is that you just need to run a macro - in which case (assuming it is open) skip the button clicking aspect and just go straight to running the macro.

Please Login or Register  to view this content.

[Mark Elkjaer]

ScottieX

I have created two sample files 'A' and 'B' (refer below). I have tried your above suggestion and it didn't work, but I am not sure if I have written the code correctly.

File 'A'
Private Sub CommandButton1_Click()
Workbooks.Open Filename:="C:\Mark\VBA sample\B.xlsm"
Application.Run "B.xlsm!CommandButton1_Click"
End Sub

File 'B'
Public Sub CommandButton1_Click()
Dim row
For row = 3 To 8
Cells(row, 4).Value = Cells(row, 2).Value + Cells(row, 3).Value
Next row
End Sub

[Mark Elkjaer]

Scottie

Since my last post I have gotten it to work. The issue was that in the 'MacroName' I had left out the sheet number.

[scottiex]

OK, if it is solved please mark as solved and add reputation if applicable.