Running Excel Sub from Access

[Climbo]

Hello there,

From Access, I want to open an excel sheet and run a sub (which is activated by a button in excel). The sheet opens without a problem but seems that I'm unable to have the Sub run (Access 11.0 object library checked). I always get "The macro 'UpdateReport_Click' cannot be found.

Set objXL = CreateObject("Excel.Application")
Set xlWB = objXL.Workbooks.Open(LastFileName)
 
objXL.Visible = True
objXL.Application.Run "UpdateReport_Click"

 

[chergh]

Try:

objXL.Run "UpdateReport_Click"

 

[Climbo]

Already tried this variant, getting same error

 

[chergh]

The name sounds more like a click event associated with a button on the userform.

Try something like

objXL.UserFormName.UpdateReport_Click

 

[DCrake]

Here is a link to a similar problem
http://support.microsoft.com/kb/219905

 

[Climbo]

workin'

Thanks guys