ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macros (https://www.excelbanter.com/excel-programming/390195-macros.html)

[email protected]

Macros
 
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

Macros
 

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

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
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



Jim Rech

Macros
 
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.

--
Jim
wrote in message
oups.com...
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




chet

Macros
 
On May 26, 8:09 am, wrote:
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...


[email protected]

Macros
 

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
On May 26, 10:10 pm, chet wrote:
On May 26, 8:09 am, wrote:

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...





All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com