![]() |
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 |
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 |
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 |
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... |
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