Thanks IRstuff and yakpol. I have tried yakpol's method and it works.... but only with office installed in the same directory and drive. I guess that is good enough considering most people install their office in "c:\program files" except those with dual boot.
Anyway, thanks for all...
Dear TTFN,
I tried the following code without checking the SOLVER.xla box manually and it won't work. Could you see anything wrong in the code?
The error message is:
"Compiled Error"
"Sub or Function Not Defined"
If I checked the solver.xla manually, it works fine...
Dear Dsi,
I tried your method by uncheck the solver and run the line which you recommended but it does not work. Do I need to specify the path to the library etc?
Thanks again.
EK
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...
Thanks GoodWishes!
Please bear with me as I only start learning ANSYS two days ago and I have tried to look for examples and tutorial online similar to thiw problem without success.
My question is, how do I create a number of time steps? Do I need to create a script? If possible can you please...
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...
Thanks Ivymike,
Sorry for my late reply as I am away for few weeks.
Having "count" variable (i) in one column and a column next to it is a good idea. However, I am trying to write a visual basic program for excel which helps me fill in the cell with formula. As you know, if I do...
Dear IvyMike,
Thanks for your reply. The example which I gave is gross simplification. The actual formula which is much more complex. Sorry for causing misunderstanding in my question.
Regards,
YEN
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...