<div>
Well, when it has &quot;recently&quot; started to not work as intended, then you should take a look on what has &quot;recently&quot; changed.
</div>


Well, when it has "recently" started to not work as intended, then you should take a look on what has "recently" changed.

<div>
<div class="content wysiwyg-content">
I have a file which has VBA code written using a 32 bit Excel 2010. &nbsp; It has been working fine for a client who is using a 64 bit Excel 2010. &nbsp; It has recently started crashing on the clients computer and we cannot determine why. &nbsp;In addition, it has just started to increase in size whenever some of the macros are run. &nbsp; This increase in size is also happening to a file it is sharing data with. &nbsp;In checking, this data is not visible and when Ctr end is used the cursor ends up significantly below and to the right of the actual data in both files.<br />
<br />
I am not sure if the two problems are related and would appreciate suggestions on how to eliminate them both.
</div>
</div>


I have a file which has VBA code written using a 32 bit Excel 2010.   It has been working fine for a client who is using a 64 bit Excel 2010.   It has recently started crashing on the clients computer and we cannot determine why.  In addition, it has just started to increase in size whenever some of the macros are run.   This increase in size is also happening to a file it is sharing data with.  In checking, this data is not visible and when Ctr end is used the cursor ends up significantly below and to the right of the actual data in both files.

I am not sure if the two problems are related and would appreciate suggestions on how to eliminate them both.

32 bit and 64 bit Excel along with file size increases

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.