98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel-xp-training - Excel Macros
excel-xp-training - Excel Macros
Resolved · Low Priority · Version Standard
Fri 11 Jan 2008, 10:33Delegate Jane said...
Jane has attended:
Project Introduction course
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?
Wed 23 Jan 2008, 16:35Trainer Katie said...
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
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 tip:Convert Text into NumberSome times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions |
