Dear All,
I realised that not all Excel comes with Solver.xla "checked" as default (in Visual Basic Module). As a result, some of the macro I wrote which uses solver will not work in those computers unless the user manually select the solver check box.
Hence, I am wondering if...
Dear All,
I am new to ANSYS and need help and advice on how to plot graphs in ansys.
Say I manage to create a simple cantilever and solved it in Solution Menu. What should I do next? I did go into Time-History Postprocessor and follow the help files. But it does not work. I think I am a bit...
Dear All,
I am looking for a way to calculate the area under a non linear graph. I know it can be easily done using spreadsheet but are there any way which I can utilise Visual Basic to do all the calculation in the background and come out with one results.
I have:
~~~~~~~
1. Equation of the...
Dear All,
My question this time is a bit harder:)
I am trying to fill a column with a bunch of formula BUT I need the formula to increase by by the product of i as we go down the cells.
From the following simple example you will see that I am trying to fill 11 cells beginning with...
Dear All,
Can someone please give me some direction on how to call the "Random Number Generation" in "Data Analysis" Addins using visual basic?
The following is an attempt to try and record the macro but
it doesn't work. Please help.
_____________
sub random()...
Dear all,
I am new in VBA for Excel and currently writing some procedures for my research. The following is a simple code which I wrote but I wish to extend it's capability:
_____________
Sub generatedata()
Max_displacement = InputBox("Enter Maximum Displacement: ")
For i = 0 To...
