View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Form In .xla file

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

"Mike H." wrote:

How do I reference a form that is located in an add-in xla file? The name of
the xla file is dailymods.xla so I tried:
dailymods.userform2.show
but it doesn't work. Ideas?