Global array data got erased after removing reference in VBA

  • Thread starter Thread starter Santh
  • Start date Start date
S

Santh

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
 
There are certain documented instances when global variables are reset.
These include things like errors. There are other undocumented instances
when global variables are also reset.

You may want to check msdn.microsoft.com and support.microsoft.com for more
on your specific problem.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use spreadsheet cells for global variable space? 2
Question about globally declared array not available in function 6
Remove XLA as a reference in VBA 1
distribution of Excel Addin - errors 2
Assign macro broken after reference removed 3
Remove reference from code 3
Dynamically add a Reference to an Add-In in VBA (Excel 2000?) 2
Declare a Public Array 5

Back
Top