William Case wrote:
However, I did set up a test sheet within the "MembershipTest2.xtl"
document -- not in a new document -- and created some test macros. I
saved them in My Macros in both the Standard Library : module1 and
MytestLib Library : module1. The test macros saved in both those My
Macros libraries did *not* disappear and functioned after closing and
re-opening. They still work a day later after several opening and
closings.
It is only the MembershipLib that is disappearing.
I have just emailed "MembershipTest2.xtl" to myself. I will open it in
Excel and see what has happened to it. I am curious to see if the test
libraries are still there.
So we have solved this particular case of disappearing macros - somehow.
Notice that almost none of your macros can run with the other
application due to the completely different APIs. The differences
between the StarBasic language and VBA (Microsoft Visual Basic for
Applications) are marginal, but the thingies you talk to are completely
different.
A Basic function like this one should work with both applications
because it does not access the API:
Function CrossFoot(Param)
Txt = cStr(Param)
For i = 1 to Len(Txt)
lResult = lResult + cInt(mid(Txt,i,1))
next
CrossFoot = lResult
End Function
It uses the common functions and declarations of both basic dialects.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
