Hi Andreas; See, my response to Terry in my "Oh, Oh. Just lost all my macros !" thread.
On Thu, 2006-17-08 at 17:04 +0200, Andreas Saeger wrote: > Hi, Scott > > Scott Rhoades wrote: > > I have been working on a small project with 20 macros so far. Closed > > OOo Calc. and just now re- opened it. Went to run a macro and got the > > following error dialogue: > > > When you open calc rather than the document, having the code then you > don't have the macro availlable. How do you run the macro? Toolbar? > Shortcut? Event driven? > > > "A Scripting Framework error occured while running the Basic script > > vnd.sun.star.script:MembershpLib.AgendaMan.RemoveAgenda?language=Basic&location=document. > > Message: BasicProviderImpl:getScript: no script!" > > > > ?language=Basic&location=document > You definitively saved the macro in a document. Is that document loaded? > That document has exactly one StarBasic script-container, containing > library "MembershpLib", containing module "AgendaMan" with Sub RemoveAgenda. > Indeed, the macro is lost if you did not save the macro with it's > containing document. Yes. That document was loaded. I've had time today to think about Terry's response. My document, "MembershipTest2.xtl", is in the Excel format. It has been eliminating my library and macro for the project. Terry suggested that that was the fault of the format. 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. -- Regards Bill --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
