Guest guest Posted December 9, 2003 Report Share Posted December 9, 2003 Hare Rama Krishna Namaste Neeraj, You are a champion and your suggested solution did worked for me and thank you very much for that. I have done the following as per your suggesion:- 1) Copy the "swedll32.dll" into c:\winnt and c:\winnt\System32 folder (for windows 2000 users) Regards Raghunadha Rao vedic astrology, Neeraj Gupta <gupta_neeraj_2000> wrote: > ~ Om Namah Shivaya ~ > > Dear List Members, > > Whoever is facing problem of getting #VALUE. Kindly do > the following. > > 1) Copy the "swedll32.dll" into c:\winnt and > c:\winnt\System32 folder (for windows 2000 users) > > 2) Windows98 users, plz copy "swedll32.dll" file to > c:\windows\System32. > > 3) Or wherever you have installed your operating > system. Other OS users may try to search "*.dll" files > on their system, and in the directory in which you get > maximum .dll files (it is the directory in which OS is > installed) > > Problem was that sunrise is a function defined in > excel chart, and it's definition is in "swedll32.dll" > file. So Excel was unable to find function and hence > it was diplaying #Value (means no result) > > If I am writing very much technical, kindly excuse me > (I have studied computers most of the time). I hope > the above should solve the purpose for most of the > users. If not, please write to me with telling what > operating system you are using, and I might be of some > help to you. > > > Kind regards, > > Neeraj Gupta > > > --- Ramadas Rao <ramadasrao> wrote: > > > > ` nmae naray[ay, > > om namo näräyaëäya| > > Dear Robben, > > Thanks for helping me.I will try this also. > > With Sri Hari Vaayu Naama Smarana, > > Ramadas Rao. > > > > Robben Hixson <passage@b...> wrote: > > Hare Rama Krishna > > > > I also had problems, getting #VALUE. I found that in > > my case when the 'swedll32.dll' was extracted by > > Winzip into c:\Windows\system folder it had instead > > created a subfolder - 'jyotish calc' - under > > windows\system and put the '.dll' there. After > > moving 'swedll32.dll' out of the subfolder and into > > windows\system it ran perfectly. This may work for > > you. > > > > Robben > > > > Ramadas Rao wrote: > > > > ` nmae naray[ay, > > om namo näräyaëäya| > > Dear Neeraj Gupta, > > Thanks for the mail.I have tried as you said but of > > no use.There are no values.Please see any other > > method to solve this problem.I have made Macros > > enabled. > > With Sri Hari Vaayu Naama Smarana, > > Ramadas Rao. > > Neeraj Gupta <gupta_neeraj_2000> wrote: > > ~ Om Namah Shivaya ~ > > > > Dear Rao Nemani, > > > > Just increase the width of that column, in which you > > are getting #VALUE!. You can either do it by > > dragging > > the column on the top, or double click exactly > > between > > the two columns. Say column B and C are there. it > > would be written like A | B. So double click > > precisely > > at the vertical dividing line. The all values will > > be > > displayed. > > > > Hope, it helps you. > > > > Regards, > > > > Neeraj Gupta > > --- Rao Nemani wrote: > > > Hare Rama Krishna > > > > > > Namaste Sarajit Ji, > > > > > > I have set my security to medium and enabled the > > > macros. > > > But when I tried to change the birth date > > > immediately, I > > > see "#VALUE!" all over the spread-sheet and I am > > not > > > able > > > to enter my own birth details to get the different > > > charts. > > > > > > Can you and some one please help me to understand > > > what and > > > how to run this macro to work for any given birth > > > details. > > > > > > Thanks for your help in adavance. > > > > > > Regards > > > Raghunadha Rao > > > > > > > > > > > > vedic astrology, "Sarajit > > > Poddar" > > > wrote: > > > > || Jaya Jagannath || > > > > Dear Ramadas, > > > > > > > > You need not put any planetary longitudes, you > > > only need to put the > > > > Date, Time, Longitude and Latitude. The excel > > > sheet shall calculate > > > > everything on its own. > > > > > > > > You need to however, enable macro written for > > it. > > > In most of the > > > > windows O/S it asks whether you would like to > > > enable the macro, > > > when > > > > the security is set to medium. > > > > > > > > Regards > > > > Sarajit > > > > > > > > > > > > > ` nmae naray[ay, > > > > > om namo näräyaëäya| > > > > > Dear Sarajit, > > > > > Really this is a good work.Now I wanted to > > > clarify from you that > > > is > > > > that I have to put all the figures from my chart > > > like not only > > > > date,time,lat. and Long.but also all planetary > > > Long.etc.? > > > > > With Sri Hari Vaayu Naama Smarana, > > > > > Ramadas Rao. > > > > > "J. Weiss" wrote: > > > > > > > > > > @page Section1 {size: 8.5in 11.0in; margin: > > > 1.0in 1.25in 1.0in > > > > 1.25in; mso-header-margin: .5in; > > > mso-footer-margin: .5in; mso-paper- > > > > source: 0; }P.MsoNormal { FONT-SIZE: 12pt; > > MARGIN: > > > 0in 0in 0pt; > > > > FONT-FAMILY: "Times New Roman"; > > mso-style-parent: > > > ""; mso- > > > pagination: > > > > widow-orphan; mso-fareast-font-family: "Times > > New > > > Roman"; mso-ansi- > > > > language: EN-GB}LI.MsoNormal { FONT-SIZE: 12pt; > > > MARGIN: 0in > > > 0in 0pt; > > > > FONT-FAMILY: "Times New Roman"; > > mso-style-parent: > > > ""; mso- > > > pagination: > > > > widow-orphan; mso-fareast-font-family: "Times > > New > > > Roman"; mso-ansi- > > > > language: EN-GB}DIV.MsoNormal { FONT-SIZE: 12pt; > > > MARGIN: 0in > > > 0in 0pt; > > > > FONT-FAMILY: "Times New Roman"; > > mso-style-parent: > > > ""; mso- > > > pagination: > > > > widow-orphan; mso-fareast-font-family: "Times > > New > > > Roman"; mso-ansi- > > > > language: EN-GB}A:link { COLOR: blue; > > > TEXT-DECORATION: > > > > underline; text-underline: > > > single}SPAN.MsoHyperlink { COLOR: blue; > > > > TEXT-DECORATION: underline; text-underline: > > > single}A:visited { > > > COLOR: > > > > purple; TEXT-DECORATION: underline; > > > text-underline: > > > > > single}SPAN.MsoHyperlinkFollowed { COLOR: > > > purple; TEXT- > > > DECORATION: > > > > underline; text-underline: > > > single}SPAN.EmailStyle17 { COLOR: > > > > windowtext; FONT-FAMILY: Arial; mso-style-type: > > > personal-compose; > > > mso- > > > > style-noshow: yes; mso-ansi-font-size: 10.0pt; > > > mso-bidi-font-size: > > > > 10.0pt; mso-ascii-font-family: Arial; > > > mso-hansi-font-family: Arial; > > > mso- > > > > bidi-font-family: Arial}SPAN.GramE { > > > mso-style-name: ""; mso-gram- > > > e: > > > > yes}DIV.Section1 { page: Section1}OL { > > > MARGIN-BOTTOM: 0in}UL > > > { > > > > MARGIN-BOTTOM: 0in}Dear Sarajit, > > > > > > > > > > Good initiative and nice work indeed. > > > > > Thank you. > > > > > > > > > > Kind regards > > > > > /Jay Weiss > > > > > http://www.alvicomm.com > > > > > > > > > > - > > > > > Sarajit Poddar > > > > > varahamihira ; vedic- > > > astrology ; > > > > > > > > > Sunday, December 07, 2003 6:09 AM > > > > > [vedic astrology] Jyotish Calculator > > in > > > Excel > > > > > > > > === message truncated === > > > ===== > http://www.geocities.com/master_minds_india/ > > > > New Photos - easier uploading and sharing. > Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.