LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Alarm function, disable sound if data is erased offdah3z Excel Worksheet Functions 1 July 21st 09 08:13 PM
Graph data series formulas: How to global-change all sheet reference to formula [email protected] Excel Discussion (Misc queries) 1 January 20th 09 05:32 AM
How Do I Recover the Erased Data [email protected] Excel Worksheet Functions 1 August 8th 07 02:34 PM
public or global array shishi Excel Programming 2 February 6th 06 09:29 PM
Global array declare Souris Excel Programming 3 August 20th 05 11:38 AM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"