![]() and some "Long" are supposed to remain the same, depending on what they do.Unfortunately, after adding ' PtrSafe' everywhere, though the VBA errors stopped, but the values are not being displayed/calculated properly in the cells.įrom a post on 64 Bit in VBA from Microsoft, it would seem that we also need to modify some of the data types such as: Amended Statement: Private Declare PtrSafe Function.Original Statement: Private Declare Function. ![]() I am no good in VBA, however, after digging over the Internet, a few websites proposed that for 64bit office (Excel), we should amend (for each declaration) the codes to something like that: Please review and update Declare statements and then mark them with the PtrSafe attribute.Īs I said above, it works only in 32bit office (Excel) but it won't work in my 圆4 Excel However there seems to be a workaround but I am too much of a novice to get it. The code in this project must be updated for use on 64-bit systems. However, when I try to run it on my end, which is on Excel 圆4, ASAP it's opened, the VBA editor fires up and gives me the following error: Compile error: It uses the Swiss Ephemeris file ( swedll32.dll) to do a lot of astronomical calculations. I have an excel file, which has some modules in it, and works flawlessly in Office (Excel) x86.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |