Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

Re: Calculation Software and problem with VBA module

[Subject Prev][Subject Next][Thread Prev][Thread Next]
The code is not backward compatible with version Excel'97.
If you desire, I can 'tickle' it to be functional....
CTruax



----- Original Message ----- 
From: "Jeremy South" <jslist(--nospam--at)jenkins-engineering.com>
To: <seaint(--nospam--at)seaint.org>
Sent: Tuesday, July 20, 2004 1:51 PM
Subject: Re: Calculation Software and problem with VBA module


| Chris and Bill:
| 
| Thanks for the tips. One reason why I haven't jumped to the more advanced
| features like arrays is I'm not always sure how the advanced features can
| help in MY calculations.
| 
| Next problem:
| I downloaded the following VBA module, but get an error message when I try
| to view the Display Sheet worksheet. The VB editor pops up with a window
| that says:
| 
| Compile Error:
| Sub or Function not defined
| 
| I'm using an older version of Excel97--could that be the problem?
| 
| Jeremy South, EI, LSI
| Jenkins Engineering
| Tupelo, MS
| 
| ******Original Message*****
| I had written this VBA module some time ago to display the Excel formulas in
| a human-readable form, similar to MathCad. If you can use it or modify it,
| feel free to do so.
| 
| (Since I was not able to post this file to this list,) Feel free to download
| a test Excel file containing the VBA module from:
| http://struct.home.att.net/VBA.html
| 
| Note: It requires two sheets. Prepare the first sheet as usual - with cells
| containing formulas where needed. The 2nd sheet is a replica of the 1st
| sheet, except that the cell addresses in the Excel formulas will be replaced
| with the corresponding cell values, presenting the formulas in a
| human-readable form. Units will be automatically appended.
| ******Original Message*****
| 
| 
| 
| 
| ******* ****** ******* ******** ******* ******* ******* ***
| *   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
| * 
| *   This email was sent to you via Structural Engineers 
| *   Association of Southern California (SEAOSC) server. To 
| *   subscribe (no fee) or UnSubscribe, please go to:
| *
| *   http://www.seaint.org/sealist1.asp
| *
| *   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you 
| *   send to the list is public domain and may be re-posted 
| *   without your permission. Make sure you visit our web 
| *   site at: http://www.seaint.org 
| ******* ****** ****** ****** ******* ****** ****** ********

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: http://www.seaint.org 
******* ****** ****** ****** ******* ****** ****** ********