Philippe, Thanks. That was a good way for me to do it.
Cheers, Mark On 6/26/07, PhilM <[EMAIL PROTECTED]> wrote:
Mark, You could simply copy your marcos in a text file. Send the text file to the other machine and copy its content to Module 1. Philippe Mark Knecht a écrit : > Hi Terry, > Thanks for the response. Sorry for my late reply. > > I am still unable to make this work. > > 1) I have an OO spreadsheet on one machine. It's called ibd100.ods. > When I use this spreadsheet on this specific machine the macros work. > > 2) When I look at Tools->Macros->Organize Macros->OpenOffice.org Basic > I see the macro existing under "My Macros->Standard->Module 1" named > cptoa1. > > 3) When I transfer this spreadsheet to another machine the macros don't > work. > > 4) On the new machine hen I look at "My Macros->Standard->Module 1" > the cptoa1 macro doesn't exist explaining why it doesn't work. > > OK - how to get the macro out of the first machine and over to the > second machine? > > Earlier Anthony suggested (I think) to export the macro. However when > I use the 'Organizer' button I cannot find an export function to > export the macro to a file. The help file doesn't talk about exporting > macros as far as I can tell so far. > > Maybe the mistake is having the macro in the My Macros group? Should > it be in the spreadsheet name group? > > Anyway, I still cannot get the macros over to the second machine so > I'm really in need of some help. > > Thanks, > Mark > > On 6/21/07, TerryJ <[EMAIL PROTECTED]> wrote: >> >> Are you using the .ods format? Macros would not, I think, be >> converted to >> the .xls format. >> >> >> Mark Knecht wrote: >> > >> > Hi Anthony, >> > The macro was developed on the first machine and in the spreadsheet >> > that I wanted to use it in. That spreadsheet should (I think) already >> > have the macro in it, shouldn't it? >> > >> > However when I move that spreadsheet to a second machine I don't >> > see the macro in the spreadsheet on the second machine. I go back to >> > the first machine and look at the spreadsheet I emailed and I do see >> > it. >> > >> > This leaves me confused as to where the macro resides. Is it in the >> > spreadsheet on the first machine or is it in OpenOffice on the first >> > machine? >> > >> > Is there anything I need to do on the second machine to enable >> > macros? I was guessing that maybe the second machine cannot run macros >> > at all until I enable some setting but I haven't found that yet. >> > >> > I'll try exporting the macro and moving it to the second machine >> > and then importing it there. >> > >> > Thanks for your help. >> > >> > cheers, >> > Mark >> > >> > On 6/18/07, Anthony Chilco <[EMAIL PROTECTED]> wrote: >> >> Hi Mark, >> >> On the PC where the macros work, go to the organize macros dialogue, >> >> click the 'Organizer' button and select the 'Libraries' tab. Find the >> >> macro, select it and click the 'export' button. Select the spreadsheet >> >> that you want them macro in, then click the import button. Import the >> >> library that you just exported. Save the spreadsheet. >> >> tc >> >> >> >> Mark Knecht wrote: >> >> > Hello, >> >> > I have a spreadsheet that has some conditional formatting >> macros in >> >> > it. If I email this spreadsheet to myself and then download it on a >> >> > new PC it seems the macros either aren't in the spreadsheet or >> aren't >> >> > activated. >> >> > >> >> > When I look in Tools-Macros->Organize Macros->Openoffice.org Basic >> >> > on the machine where they aren't working it seems I don't see the >> >> > macro that I see on the original machine. >> >> > >> >> > How do I transfer the macro as part of the spreadsheet so that >> >> > another user can use it? >> >> > >> >> > Thanks, >> >> > Mark >> >> > >> > >> > >> -- >> View this message in context: >> http://www.nabble.com/Macros-not-active-on-new-machine--tf3937729.html#a11243994 >> >> Sent from the openoffice - users mailing list archive at Nabble.com. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
