#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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...

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default 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...





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros in Personal.xls that would create two toolbars and buttonswith assigned macros Brian Day Excel Programming 1 March 29th 07 11:20 PM
choose default macros Not Enabled / Macros Enable Setting BEEJAY Excel Programming 2 June 30th 06 01:07 PM
weird saving of a document with macros resulting with macros being transfered to the copy alfonso gonzales Excel Programming 0 December 12th 04 09:19 PM
Macros inside macros, and pasting into macro code. pagelocator[_2_] Excel Programming 1 November 24th 04 09:11 AM
convert lotus 123w macros to excel macros rpiescik[_2_] Excel Programming 1 September 19th 04 12:41 PM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"