I have two workbooks:
1) Settings
2) Schedule
The named range I am using ("Dates") is in the Schedule workbook, and it is updated dynamically using an offset formula.
The consolidation of such workbooks would make the file lag badly, so I don't want the named ranges consolidated into one worksheet.
I have tried all sorts of things to resolve this, but I am having some severe trouble.
Here was the most promising (adapted) solution I could find, but still no luck:
Any pointers?
Zack
1) Settings
2) Schedule
The named range I am using ("Dates") is in the Schedule workbook, and it is updated dynamically using an offset formula.
The consolidation of such workbooks would make the file lag badly, so I don't want the named ranges consolidated into one worksheet.
I have tried all sorts of things to resolve this, but I am having some severe trouble.
Here was the most promising (adapted) solution I could find, but still no luck:
Code:
Dim wb As Workbook
Dim wks As Worksheet
Dim path As String
'Turn off screen updating
Application.ScreenUpdating = False
path = "C:\Users\Zack\Documents\Debate Program"
Set wb = Workbooks.Open(path & "Schedule and Entries Database.xlsm", True, True)
'Open source workbook
With ThisWorkbook.Worksheets("Schedle")
'read data from source workbook
.Range("Tournaments").Formula = wb.Worksheets("Schedule").Range("Tournaments").Formula
End With
'Close the source book without saving changes
wb.Close False
Set wb = Nothing
'Turn on screen updating
Application.ScreenUpdating = True
End Sub
Any pointers?
Zack