Using/adjusting macros on other pc

[Tine]

Hi

I made macros on (let's say) pc 1, saved in Personal Workbook (on a USB-stick).
I wanted to work further with them on another pc ("pc2"), from my USB-stick. --> I opened the excel-file, but did not find back my macros...

Solutions?
1. I tried to change some hide/unhide-buttons, but this didn't change anything.
2. I did find my PERSONAL.xls on pc1 (in C:\Documents and Settings\...) and copied it to my USB-stick, but opening this on pc2 (and on pc1) gave the message:

"A document with the name "PERSONAL.XLS" is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that's currently open, or rename one of the documents."

--> I changed the name and could open the macros (of Personal Workbook) from my USB-stick on pc2.
3. I guess (& hope) there's another way (better than n°2), but how?

Thanks in advance!

 

[Trevor G]

Welcome to the forum,

When you create Macros / Subroutines in your personal workbook or any for that matter you are using module sheets, it would be easier for you to export then import the modules sheets from pc to pc.

 

[Tine]

Hey,

Thanks!

The only pity thing is that I should export/import the module everytime I edited something in the module.

But, thanks for sure, it brought me already further!