View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Santh Santh is offline
external usenet poster
 
Posts: 1
Default Global array data got erased after removing reference in VBA

Hi All,

I have an array of integers declared in a module and I have initialized
the elements using sub function in my VBA module. I have another .xla
loaded in my workbook which removes the file references(.dll, .exe)
programatically in one function. When this .xla function is executed
the array declared in my VBA module loses its data and set to Empty.

This same thing is happening when I remove any reference in
Tools-References menu item also.

Is there any way to resolve this problem. Any help is appriciated.

-Thanks in Advance
Santh