ah...in that case follow these two steps:
Step 1: Add the following to the OnClick event of your command button:
Add the command button to your form, in the HyperLink address Property click the "..." and browse for the Excel file you want to open, select it and save the form.
Step 2: open the Excel Document and select Tools, macro, Visual Basic Editor. Where you see (General) in the VB Editor click the down arrow and select the Workbook you want to update The following should appear in the VB Editor:
Private Sub Workbook_Open()
End Sub
Add Me.RefreshAll to the code, it will then look like this:
Private Sub Workbook_Open()
Me.RefreashAll
End Sub
Save and close the workbook....
ta-da!