Run VB sub from one workbook to another
Thanks - I knew it was something simple.
--
Hmm...they have the Internet on COMPUTERS now!
"Gary''s Student" wrote:
Consider:
Sub MDW()
ActiveWorkbook.FollowHyperlink Address:="file:///c:\model.xls"
Application.Run "Model.xls!my_sub"
End Sub
The FollowHyperlinks will open the file if not already open.
--
Gary''s Student
gsnu200712
|