copy a mocro to another pc. HELP!!!!!!!!!!!!!!!!!!!!

  • Thread starter Thread starter vincenzo
  • Start date Start date
V

vincenzo

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.
 
Ron de Bruin said:
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.
Click to expand...

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

Tools>Options>General 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
Start>Run "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 Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.
 
Back
Top