Software

Ask something
Discussion Locked

excel/97/xp macros question

0 helpful
6 replies

by rg11

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a computer with win95 and office97, we have documents on this pc done in excel97 which contain macros.
I have another computer with xp and office xp. When I copy the excel workbook from the old pc to the new one(over a network) the macros are not there when I access the macro screen from excel 2002. I am assuming that the macros are not saved in the actual workbook but saved on the old win95 hard drive. How do I correct this...

6 replies

by dklippert

I assume you have gone to Tools>Options Security and set the Macro Security to Medium.
If the macros are not in the Workbook, they could have been stored on the old machine in Personal.XLS. You can use the VB editor to copy modules to the workbook

by rg11

I am new to macros and vb. How do I copy the modules over???Not sure where to begin..

by dklippert

Open your E97 workbook on the original machine.

Go to Tools>Macro Visual Basic Editor
If the macros are in the Personal.xls file you can locate the module and drag it from VBAProject (PERSONAL.XLS) to VBAProject (Your EX97 workbook). It will create a copy.

by rg11

Thanks I went into the visual editor and exported the file from one pc to the network then imported the file from another pc and saved it....It worked...Why didnt you think of this yesterday????

This discussion is closed to new replies.