Is the form opened?

try something like this
workbooks.open filename:=dailymods.xla     'include path if necessary
set frm = ActiveWorkbook   'reference  for by this name or
                                       'Workbooks("dailymods.xls")
                                       'when using workbooks don't include
path

In your dailymods.xla Include a sub or function to show the form, it
probably already has one, eg

Function RunForm(a As String) As Variant
UserForm1.Caption = a
UserForm1.Show
RunForm = "Return value"
End Function

One way to call RunForm from other projects is with 'Run', eg

Sub test()
Dim s As String, res
s = "called from " & ThisWorkbook.Name
res = Application.Run("dailymods.xla!RunForm", s)
MsgBox res
End Sub

Regards,
Peter T

In a similar vein, but a little more basic, how do you create a form in VBA,
or in Visual Studio and import it through VBA?