Link to excel doc

[elsiegee1]

Hi,

I'm new to this so please go easy!

I have an excel document which automatically refreshes data gathered from an access db.
I need to put a button on the switchboard on the same db to open the excel document, basically to make it easy for others to find.
I have tried hyperlinks but it doesn't want to play. It locks the db and then won't refresh the information.
I know i'm missing something blindingly obvious, can someone help?!

Thanks
elsiegee

 

[1eye1vision]

Try This code on the onclick function of your button

Dim MyApp As Object


Set MyApp = GetObject(""C:\Yourfolder\YourFile.xls")

With MyApp

.Application.Visible = True
.Parent.Windows(1).Visible = True

End With