Search results for query: *

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 TKsolver for your input!

Jproj, thanks for the offer!!! Can you please email me your codes? My email address is: yliew@civag.unimelb.edu.au Thanks again!

Thanks Troy. I have since use calculus to find the area under the graph. Thanks for your advice! Regards, YEN

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...

Many thanks to jproj and malone for contributing to the discussion. Jproj, what you have suggested is exactly what I need. Thanks!!! Regards, YEN

Prex thanks for your quick reply but I am not sure if I understand what you mean. Could you please elaborate? Sorry. Regards, YEN

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 for your help. It's working for me now. Thanks!

Many thanks IvyMike!!!! That's exactly what I need. Thank you very much ... really appreciate your help! Regards, YEN

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...