View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Wescott Eric Wescott is offline
external usenet poster
 
Posts: 3
Default Problems running my app more than once

I wrote a little VBA app that reads some data from a workbook and
creates a new one based on the information. Well if certain
information from the source book is invalid I report it to the user to
correct and then rerun the app. However if you rerun the app after
correcting the source workbook the final created workbook isn't always
the same. However if you save your data, exit excel and reopen and run
it is always consistant. I do have a few globals in the app.. Is there
something I need to do in order to reset all data to initial values?

(Here are my globals)
Option Explicit
Private ID() As String, amnt() As Currency, ArraySize As Integer,
ArrayPos As Integer, ERRORS As Boolean

Thanks
Eric