Hi John,
When you import a module it can generally be found as a new module (under
the name it was exported with originally) in the current worksheet.
If you're still having problems you can copy the personal.xls file to
C:\Documents and Settings\%Username%\Application
Data\Microsoft\Excel\XLSTART. This is the default location on an XP/2000
machine
regards
Paul
"JRM " wrote in message
...
I have a large macro which I urgently need to copy to another PC.
Currently it is in Personal.xls on PC.1
I've tired exporting from Visual Basic Editor but cann't seem to find
where it goes when I import it. Also I don't appear to have
Personal.xls on the 2nd PC - do I need to create it & if so how.
All help gratefully received with thanks. (& please make it simple !)
John
---
Message posted from http://www.ExcelForum.com/