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]
