Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel-xp-training - Excel Macros
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel-xp-training - Excel Macros
Resolved · Low Priority · Version Standard
Reply
Excel Macros
Hello,Can you help me i have created a macro on my pc and i want to copy it to another persons pc, is there an easy way to do this?
For upcoming training course dates see: Pricing & availability
RE: Excel Macros
Hi Jane,Thanks for your question.
You can try exporting the macro.
- 1. Open your Visual Basic window
2. In the Project Explorer window (top left corner), under the file PERSONAL.xls, you can see the MODULE folder
3. Right click on the particular MODULE name
4. Choose EXPORT FILE...
5. Name & save it.
Email this file (*.bas) to your colleague, on their computer.
- 1. Open a new Excel worksheet
2. Open Project Explorer Window
3. Right click on the new file name (e.g. Book1)
4. Choose IMPORT FILE...
5. Locate and press OPEN.
Hope this helps
Regards,
Katie
RE: Excel Macros
thanks Katie I will give this a go...Jane
|
 |
Use Prince2 And Celebrate Project Success Floundering projects can be turned around with the application of the Prince2 management system. The technique is used around the globe to make sure campaigns run smoothly and that all members of a team are working together effectively. » Article: Prince 2 practitioner course |
» Forum post: Excel 2007 |
What is a pivot table?
