Macros

[jamalhakem]

Hi
I have a list of macros and modules on a PC at work, I will leave this
work and want to copy these macros to my flash memoey and then delete
them from the hard disk completly, any help?
Thank you in advance
Jam

 

[Don Guillett]

I think you will find that the macros are the PROPERTY of your employer. To
remove them might invite a lawsuit or worse.

 

[Jim Rech]

Bearing in mind Don's warning, Excel macros and modules do not exit on their
own. They are always part of workbooks (aka files) so you have to find the
ones they are in and do your work on them.

 

[chet]

Hi
I have a list of macros and modules on a PC at work, I will leave this
work and want to copy these macros to my flash memoey and then delete
them from the hard disk completly, any help?
Thank you in advance
Jam

If, as mentioned previously, these work products are available to you,
the simplest method of producing copies is to open the Visual Basic
Editor from the workbooks which contain the macros and click File >
Export File... which will produce files with the .bas extension.
These files can be manipulated as text files. To use these macro
copies, open Excel, open Visual Basic Editor, and click File > Import
File...

 

[jamalhakem]

Hi
Those macros are written by me during many years, they only do belong
to me, I have the text in VB editor, but I want to remove them from
the PC, and this is as you told me
Thank you
Jam