Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by yliew

  1. yliew

    Automatic Load Solver.xla

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

    Automatic Load Solver.xla

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

    Automatic Load Solver.xla

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

    Automatic Load Solver.xla

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

    Calculating Area Under the Graph Using Visual Basic

    Thanks TKsolver for your input!
  6. yliew

    Calculating Area Under the Graph Using Visual Basic

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

    Calculating Area Under the Graph Using Visual Basic

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

    Load Deflection Graph and List

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

    Load Deflection Graph and List

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

    Calculating Area Under the Graph Using Visual Basic

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

    Calculating Area Under the Graph Using Visual Basic

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

    Calculating Area Under the Graph Using Visual Basic

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

    AddIns

    Thanks for your help. It's working for me now. Thanks!
  14. yliew

    Another Question for VB Pro

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

    Another Question for VB Pro

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

Part and Inventory Search

Back
Top