Aktivere makro i Access fra Excel

You are going to have to either automate Access from Excel and run your update query, or start Access with parameters where you can include whcih macro you want to run when your database opens.

If you cant do this your self or havent received an answer by this evening then I will give an example when I get home from work!

Det vil jeg glæde mig til at se!

Now I dont know much at all about Excel but it should be the same as other Office applications. You will need a reference to MS Access.

The code is behinde a button but I am sure you can place it elsewhere.

Private Sub Command1_Click()
Dim acc As Access.Application

    Set acc = CreateObject("Access.Application")

    acc.OpenCurrentDatabase "C:\Path\test.mdb"

    acc.DoCmd.RunMacro "YourMacro"

    'This makes access visible
    acc.Visible = True

End Sub

Det virker bare ski... godt, mange tak, Terry

great :o)
is there still problems accepting answers?

kial>have you accepted this answer?

hellooo.....

....

kial>How about responding to this question, you have received your help!

kial>You have a couple of days and your time is up, after that admin will be  contacted!

Closing

taht would be a very good idea :o)

kial>It would be very nice if you could close that way you have a much better chance of getting assistance in the future
http://www.eksperten.dk/spm/482193

Yes, yes I understand!