query question

[dantb]

Hi All, what I was wondering is if there is a vba to start (all query's in a workbook), I am trying to open a excel file that has query's in it, from an opened excel file. The file opens and all seams fine, but the automatic queries do not initiated. The queries are from xls dbase's. This is what I have been using to open the workbook. Thanks Dan
Private Sub Cmdcustomer_Click()
ChDir ("C:Unit Price")
NewFn = Application.GetOpenFilename(fileFilter:="Excel Files (*.xls), *.xls", Title:="")
If NewFn = False Then
Exit Sub
End If
Workbooks.Open Filename:=NewFn
Workbooks("Main.Xls").Close SaveChanges:=False
Exit Sub
End Sub

 

[dantb]

Hi all finally figured it out. Needed a code in the workbook that I am opening. Incase anyone ever gets into the situation I was in, here it is, too simple

Private Sub Workbook_Open()
ActiveWorkbook.RefreshAll
End Sub