View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
zSplash zSplash is offline
external usenet poster
 
Posts: 21
Default set path for Application.Run

I have an addin with userforms that I am trouble accessing. I have tried
the following code:
Application.DefaultFilePath = "C:\Documents and
Settings\Username\Application Data\Microsoft\Addins\"
Application.Run "MyAddin.xla!TL.ShowUserform1"

I get "Run-time error 1004" - "'MyAddin.xla could not be found..."

Any suggestions, guys?

TIA