assigning marcos
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Assigning Marcos

Assigning Marcos

resolvedResolved · Medium Priority · Version 2003

replyReply Fri 30 Sep 2011, 12:13Delegate Christina said...

Christina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Assigning Marcos

Hi there,

I wonder if you can help me. I have a macro of which I need to use on various files, is there a way to do this?

Thank you

For upcoming training course dates see: Pricing & availability

replyReply Mon 3 Oct 2011, 16:42Trainer Anthony said...

RE: Assigning Marcos

Hi Christina, thanks for your query. You need to bundle your code as a standalone add-in for it to work on different files. Here's a link to a walkthrough on how to do this:

http://www.bettersolutions.com/excel/ECA723/LD825611882.htm

Hope this helps,

Anthony

Mon 10 Oct 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
access 2003 training and other Microsoft training courses.

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard