Sub CopyData_1() Dim Temp As String Temp = "'" & ThisWorkbook.Path & "¥[date.xls]Sheet1'!" With Sheet1.Range("A1:F44") .FormulaR1C1 = "=" & Temp & "RC" .Value = .Value End With End Sub总是出现打开对话框单击date.xls打开如何去掉或者隐藏对话框