Hey guys,

I have a complicated script which has several steps. It involves importing data from an excel sheet to a table and then distributing that data into 2 other tables within the database.

To achieve this I use global variables to carry over the data from script to script. It all works fine.

Except for some reason, if I try and run the script twice in a row, the second time the script gets stuck half-way. However if I close the file, reopen and try then, it works fine. So i'm guessing there's a conflict of some kind with the global variables.

Is there a way I can reset all variables once the script has run? As if I had closed the file and started from scratch?

Any and all info would greatly appreciated.

Thanks guys,

Rob

Hi Rob,

Except for some reason, if I try and run the script twice in a row, the second time the script gets stuck half-way. However if I close the file, reopen and try then, it works fine. So i'm guessing there's a conflict of some kind with the global variables.

I think we need to see the actual script or file in order to see what the script is doing.

Lee