Hello!

I'm really new to VBA and really have only just started with VBA for excel, so sorry if my question is very basic.

I've been trying to figure out how to make a macro which run when I open a specific document.

I want to make some kind of macro which asks for name and adress when someone opens the word-document or template. The macro should then fill in the name and adress into the document.

Do anyone here know how to write a macro like that and can help me out?

I know it must be frustrating getting vague questions like this, but I thought I might aswell ask while I continue to go through my VBA tutorials :P

/Björn