Hey everyone,



I'm trying to find code so that when I click on a command button in excell, it runs my database in access and refreshes the data tables there linked to in excel.

I know I need code and I know where I have to put it but I have no programming backround so I don't know how to go about it. Any help you guys can provide would be greatly appreciated

P.S. I'm finding more and more that coding knowledge would be extremely useful to have at my job, any suggestions on how to start learning

Alright I'm getting close, I now have my database and excell sheet linked but when I run my code I get an error on line 10 where is says Range ("E8"). The error is Run-Time Error "1004" Select method of range class failed.

I have no idea what goes there, I just want to make sure those data tables update. Thanks for the help!

Private Sub CommandButton1_Click()
Dim obj As New Access.Application
obj.OpenCurrentDatabase ("\\Ohhfp01\users\jhouk\My Documents\CDP Documents\Leadership Dashboard\VSG Planning Dashboard\Dashboard Live Database.mdb")
obj.DoCmd.RunMacro "Dashboard Update"
obj.CloseCurrentDatabase
Set obj = Nothing
ActiveWorkbook.Worksheets("LMR DATA").Select
Range("E8").Select
Selection.QueryTable.Refresh BackgroundQuery:=False

End Sub