Hellow there.
I have a workbook (start.xls)created in excel xp, I recorded 18 macros
and save them in the same workbook. I copy the file (start.xls)to
another computer , but the macros won't work. It sais that there is a
file with the same name alwready open. (but ther isn't). How can I
make the macros work on another computer? I will very much appreciate
your help.
Thanks.
Vince

Hi vincenzo

You must make a Add-in of the file or copy the macro's in your personal.xls.
This is a (normally) hidden workbook that is loaded automatically by Excel.
When you record a macro, you have the option of recording it to your Personal Macro Workbook.
The file, Personal.xls, is stored in your \XLStart directory.

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"vincenzo" wrote in message om...
Hellow there.
I have a workbook (start.xls)created in excel xp, I recorded 18 macros
and save them in the same workbook. I copy the file (start.xls)to
another computer , but the macros won't work. It sais that there is a
file with the same name alwready open. (but ther isn't). How can I
make the macros work on another computer? I will very much appreciate
your help.
Thanks.
Vince

"Ron de Bruin" wrote in message ...
Hi vincenzo

You must make a Add-in of the file or copy the macro's in your personal.xls.
This is a (normally) hidden workbook that is loaded automatically by Excel.
When you record a macro, you have the option of recording it to your Personal Macro Workbook.
The file, Personal.xls, is stored in your \XLStart directory.

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"vincenzo" wrote in message om...
Hellow there.
I have a workbook (start.xls)created in excel xp, I recorded 18 macros
and save them in the same workbook. I copy the file (start.xls)to
another computer , but the macros won't work. It sais that there is a
file with the same name alwready open. (but ther isn't). How can I
make the macros work on another computer? I will very much appreciate
your help.
Thanks.
Vince

Not only the macros didn't work when I copied the workbook to another
computer, but even if I copied the file (start.xls) in the same
machine , but to a different folder. I understand that when you save
the macros to the personal.xls they are available to other workbooks.
But if I save them to the same workbook,and copy the same file to
another folder shuldn't they work fine?
I don't understand why they don't work if I can see the code of the
copied file's macro , and it is identical to the original file. Any
suggestions? Thanks

Try this

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

On the Windows Taskbar
Close Excel
StartRun "excel.exe /regserver"(no quotes)OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"vincenzo" wrote in message om...
"Ron de Bruin" wrote in message ...
Hi vincenzo

You must make a Add-in of the file or copy the macro's in your personal.xls.
This is a (normally) hidden workbook that is loaded automatically by Excel.
When you record a macro, you have the option of recording it to your Personal Macro Workbook.
The file, Personal.xls, is stored in your \XLStart directory.

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"vincenzo" wrote in message om...
Hellow there.
I have a workbook (start.xls)created in excel xp, I recorded 18 macros
and save them in the same workbook. I copy the file (start.xls)to
another computer , but the macros won't work. It sais that there is a
file with the same name alwready open. (but ther isn't). How can I
make the macros work on another computer? I will very much appreciate
your help.
Thanks.
Vince

Not only the macros didn't work when I copied the workbook to another
computer, but even if I copied the file (start.xls) in the same
machine , but to a different folder. I understand that when you save
the macros to the personal.xls they are available to other workbooks.
But if I save them to the same workbook,and copy the same file to
another folder shuldn't they work fine?
I don't understand why they don't work if I can see the code of the
copied file's macro , and it is identical to the original file. Any
suggestions? Thanks