transferring macros from one PC to Another

  • Thread starter Thread starter Suman
  • Start date Start date
S

Suman

Hi,
I have some macros on one PC. The machine is very slow and I want to
format it. But I want to transfer all my macros to a CD or another PC.
Please help me in doing that. Tell me how can I do it.
Thanks Much
Suman
 
Suman, to move to another computer you can export a macro and save it, to do
this from your workbook, right-click the workbook's icon and pick View Code.
This icon is to the left of the "File" menu this will open the VBA editor,
click on the module you want to save and go to file and export file, then
save it to a CD or what ever you backup to, then import it to the new
workbook.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving macro from one PC to another 1
transfer excel menu 2
Transferring Data from one sheet to another 2
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
Copying toolbars to another computer 1
Voltage supply issue related to NUC PC Core i7 0
Transfer or copy album structure (not just photos) from iPhone 14 to PC 3
Select data to imput to macro 2

Back
Top