Hey all. I am stuck on the following problem. I have sent it
to my VAR and so far no luck.
I have a DT that needs to auto execute a function to finally drive model geometry.
The geometry is simple. The DT is not. I am incorporating a AMSE Section I code (area replacement formula) that evaluates input data (from outside sources) populates the DT via multiple sheets to finally use a VBA routine/macro to output numerical values to sheet1.
With me still?
The problem. By itself, the spreadsheet (and VBA macro/routine) performs as expected but when I incorporate the VBA routine into the DT, it hangs (really it loops) when I open the DT through the model.
I have confirmed it is the macro/routine that is the problem and not the DT.
Anyone go down this road? Any thoughts or solutions? Commiserate?
I can add the file if needed.
I have a DT that needs to auto execute a function to finally drive model geometry.
The geometry is simple. The DT is not. I am incorporating a AMSE Section I code (area replacement formula) that evaluates input data (from outside sources) populates the DT via multiple sheets to finally use a VBA routine/macro to output numerical values to sheet1.
With me still?
The problem. By itself, the spreadsheet (and VBA macro/routine) performs as expected but when I incorporate the VBA routine into the DT, it hangs (really it loops) when I open the DT through the model.
I have confirmed it is the macro/routine that is the problem and not the DT.
Anyone go down this road? Any thoughts or solutions? Commiserate?
I can add the file if needed.
Its a bit difficult to determine the issue if its hanging in a loop without seeing the actual code its running.
Would it be possible to provide the files that you are using?................... I could take a look and maybe recommend the changes or if its a relatively simple fix I could make the changes for you.
Declan McTiernan,
SW2007 SP4.0