Call a function in another spreadsheet

[SonicBoomBand]

I have a setup button in a spreadsheet that opens another spreadsheet and copies data across. But at the end of the process I need to run a function in the other spreadsheet. How do I call this function in the other spreadsheet from the process code?

I'm guessing that I am close with the code below but I'm not sure how to finish it off.

With Workbooks(RRresultsWorkbookName)
.VBProject.VBComponents
End With

Does anybody have any ideas?
Andrew

Andrew Chamberlain
National Grid Transco

 

[TonyJollans]

Hi Andrew,

You should be able to do it with Application.Run ..

[blue]Application.Run "[i]WorkBook!Procedure[/i]"[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.