【转帖】equation to create 3d curve
 

equation to create 3d curve
anyone have a macro that can create a 3d curve given an equation (or more than one equation)?
i am in the middle of making one now but with my schedule and api ability (or lack of api ability ) means it'll probably take me another two months...at least!
thanks!

lucky for you, i wrote that exact macro last week.
mahir abrahim, cswp/core. cswp/smtl
mechanical design engineer
sw 2009 sp2.1
proe wf3/4
that's good work you've done there... thank you very much!!!!
can i get a copy of this api?
please!
windows vista ultimate x64, dell m4400 2.5ghz, 4gb, quadro fx770m - sw2009 sp1
windows xp professional x64, dell 490 2.0ghz, 2gb, quadro fx570 - sw2009 sp1
sure, no problem. there you go. i hope it's helpful.
mahir abrahim, cswp/core. cswp/smtl
mechanical design engineer
sw 2009 sp2.1
proe wf3/4
mahir,
i apparently don't have the proper libraries for this (my office install is a little messy). what object library do i need for "dim xlapp as excel.application"?
charles culp, cswp
aerospace design engineer
essex industries - st louis, missouri
sw2009 sp2.1
charles,
in my reference list it specifies "microsoft excel 11.0 object library". i have office 2003 installed. if you have an older/newer version the "11.0" might be different, but it should still work. i only use basic excel functions that haven't changed in as long as i can remember. if you still have issues getting the macro to run you could try repairing or uninstall/reinstalling excel. good luck.
mahir abrahim, cswp/core. cswp/smtl
mechanical design engineer
sw 2009 sp2.1
proe wf3/4
i thought about using a free alternative to the excel engine, but i never got around to it. it would also be a separate step for users to install the additional library.
mahir abrahim, cswp/core. cswp/smtl
mechanical design engineer
sw 2009 sp2.1
proe wf3/4
it doesn't seem to like something with excel 9.0... it can't find excel.application.
don't worry about it though, i'm not sure i have a use for the macro, i just thought it was interesting.
charles culp, cswp
aerospace design engineer
essex industries - st louis, missouri
sw2009 sp2.1
maybe the object names changed since 9.0. you can try checking the autocomplete listing or vb object browser when you declare a new variable. instead of excel.application it might be xl.app or some other variant.
mahir abrahim, cswp/core. cswp/smtl
mechanical design engineer
sw 2009 sp2.1
proe wf3/4
thank for suggestion. i actually didn't set the reference properly, it works just fine without any mods with excel 2001.
charles culp, cswp
aerospace design engineer
essex industries - st louis, missouri
sw2009 sp2.1