View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mary Mary is offline
external usenet poster
 
Posts: 190
Default Compiling error! VBA Help needed

Hi Everyone,

I am having a problem integrating an Active X component in my work sheet,
where the first time I run the worksheet, it will have a compiling error
pointing at the ActiveX Component, but if I close the worksheet and then
reopen again, it runs fine. Does anyone know how I can get rid of this
problem?
The error message is:
Compile Error: Method or data member not found.
and it is pointing at this line:
Set sckMail = frmSck.Winsck
Any help would be much appreciated!

Thanks heaps!
= )
Cheers,
Mary