Assigning Marcos

Resolved · Medium Priority · Version 2003

Fri 30 Sep 2011, 12:13 Delegate 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

Mon 3 Oct 2011, 16:42 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips