Swiss Ephemeris in Excel using vba

[amar teja]

Hi all

Shortly: I want the swiss ephemeris (mainly longitudes of sun and moon) from 1900 A.D. to 2014 A.D. in excel.
Clearly: I have downloaded a software from nasa swiwin32.zip which is free ( by going through this link Index of /ftp/swisseph/programs) and when i run the software i enter my desired date and the longitudes are available as i need to get this in excel
I downloaded the excel from this link ([TABLE="width: 73"]
<tbody>[TR]
[TD="width: 73"]http://www.astrotexte.ch/sources/others/ephemeris.xls)[/TD]
[/TR]
</tbody>[/TABLE]
which is showing values what i needed when i open and while enable for editing it shows the #Name and when i enable macros it is showing #value

Can any check the code and help me in solving it??

The program interface of the software swiwin32.exe is given in this url (Programming interface to the Swiss Ephemeris)
section 18 shows in visual basic 5.0

Thanking everyone in advance!!!

 

[amar teja]

The VBA calls some functions from the dll file ( but i am unable to know whether the vba code is detecting the file or not?? as i am not getting any error if its not detecting)

 

[janschotten]

Hi,

The ephemerides filles should be in c:\ephe
and the dll in the proper dll directory. Which directory depends on the system you use, which means that it is different for the older version of windows then for windows8 c:\windows\syswow64. For older version I think it was c:\windows\system32
It works very well with mne

Greetings
Jan Schotten

Hi all

Shortly: I want the swiss ephemeris (mainly longitudes of sun and moon) from 1900 A.D. to 2014 A.D. in excel.
Clearly: I have downloaded a software from nasa swiwin32.zip which is free ( by going through this link Index of /ftp/swisseph/programs) and when i run the software i enter my desired date and the longitudes are available as i need to get this in excel
I downloaded the excel from this link ([TABLE="width: 73"]
<tbody>[TR]
[TD="width: 73"]http://www.astrotexte.ch/sources/others/ephemeris.xls)[/TD]
[/TR]
</tbody>[/TABLE]
which is showing values what i needed when i open and while enable for editing it shows the #Name and when i enable macros it is showing #value

Can any check the code and help me in solving it??

The program interface of the software swiwin32.exe is given in this url (Programming interface to the Swiss Ephemeris)
section 18 shows in visual basic 5.0

Thanking everyone in advance!!!