Recent content by yliew

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