Call Stack Available ?
in [Programming]
|
Prev: MS Excel VBA Pivot table link cell fetch records
Next: How do I add numbers in two column based on the date in another?
From: Neal Zimm on 10 Mar 2010 03:19 When browsing the Locals Window, I happened upon the call stack display. I looked in Help but could not find a way to access it with VBA. It might be handy in error processing in knowing how you got somewhere. If it's available, how do you access it? Thanks. -- Neal Z
From: Charles Williams on 10 Mar 2010 04:38 There is no way of accessing the call stack from VBA. For widely distributed addins I maintain my own global VBA stack array by adding the name of the function/sub into an array at the start and subtracting it at the end. Then the error handling can display where the error has occurred. I also use line numbers and ERL to display the line the error occurred on. regards Charles >When browsing the Locals Window, I happened upon the call stack display. > >I looked in Help but could not find a way to access it with VBA. >It might be handy in error processing in knowing how you got somewhere. > >If it's available, how do you access it? >Thanks.
From: Bob Phillips on 11 Mar 2010 04:17 I maintain a stack array too, I am glad to see that I am not the only oddball. I even call my routines PushProcedureStack and PopProcedureStack :) Bob "Charles Williams" <Charles(a)DecisionModels.com> wrote in message news:8spep5p2cha4ap1omb045lmuspja1o8s13(a)4ax.com... > There is no way of accessing the call stack from VBA. > > For widely distributed addins I maintain my own global VBA stack array > by adding the name of the function/sub into an array at the start and > subtracting it at the end. Then the error handling can display where > the error has occurred. > I also use line numbers and ERL to display the line the error occurred > on. > > regards > Charles > >>When browsing the Locals Window, I happened upon the call stack display. >> >>I looked in Help but could not find a way to access it with VBA. >>It might be handy in error processing in knowing how you got somewhere. >> >>If it's available, how do you access it? >>Thanks.
From: Neal Zimm on 11 Mar 2010 12:24 Thanks Charles, I was afraid of that. I was thinking about the method you mentioned. I'm not clear on "scope" issues with addins re: global public variables. I have an addin which opens by reference when the user's wbk is opened. There are LOTS of public vars in the addin(all have constants or the values are not changed) by the user. What happens when 2+ users at the same time use your array? I've read you have to be careful with globals when there is > 1 user. Thanks. -- Neal Z "Charles Williams" wrote: > There is no way of accessing the call stack from VBA. > > For widely distributed addins I maintain my own global VBA stack array > by adding the name of the function/sub into an array at the start and > subtracting it at the end. Then the error handling can display where > the error has occurred. > I also use line numbers and ERL to display the line the error occurred > on. > > regards > Charles > > >When browsing the Locals Window, I happened upon the call stack display. > > > >I looked in Help but could not find a way to access it with VBA. > >It might be handy in error processing in knowing how you got somewhere. > > > >If it's available, how do you access it? > >Thanks. > . >
From: Neal Zimm on 11 Mar 2010 12:27
Hi Bob, Thanks for the post. We emailed each other some time ago, I'm the guy who's working on a newspaper App. (Still working on it, had to take some time off to earn some money) and I've not forgotten about you. You gave me your email address. What's the best to contact you if your email has changed? thanks. (It was about a year ago ?) -- Neal Z "Bob Phillips" wrote: > I maintain a stack array too, I am glad to see that I am not the only > oddball. I even call my routines PushProcedureStack and PopProcedureStack :) > > Bob > > "Charles Williams" <Charles(a)DecisionModels.com> wrote in message > news:8spep5p2cha4ap1omb045lmuspja1o8s13(a)4ax.com... > > There is no way of accessing the call stack from VBA. > > > > For widely distributed addins I maintain my own global VBA stack array > > by adding the name of the function/sub into an array at the start and > > subtracting it at the end. Then the error handling can display where > > the error has occurred. > > I also use line numbers and ERL to display the line the error occurred > > on. > > > > regards > > Charles > > > >>When browsing the Locals Window, I happened upon the call stack display. > >> > >>I looked in Help but could not find a way to access it with VBA. > >>It might be handy in error processing in knowing how you got somewhere. > >> > >>If it's available, how do you access it? > >>Thanks. > > > . > |