wageslave101
Board Regular
- Joined
- Jul 18, 2007
- Messages
- 154
Hi I'm new here so I apologise if this a newbie question
I would like a workbook to automatically update from another book at the moment I've a button in a sheet that when selected does
The problem I'm encountering is that the TeamData.xls is a Shared Workbook and when I run the macro I get a message box
"This workbook contains links to other data sources..."
At which point it pauses waiting for a user to select Update or Don't Upate.
I would like this to select Update without any user intervention - is this possible?
Sincerely,
WageSlave101
I would like a workbook to automatically update from another book at the moment I've a button in a sheet that when selected does
Code:
Sub TLRefresh()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Windows("TeamData.xls").Activate
ActiveWindow.Close
Workbooks.Open Filename:="TeamData.xls"
Windows("TLRecord.xls").Activate
ActiveWindow.WindowState = xlMaximized
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
The problem I'm encountering is that the TeamData.xls is a Shared Workbook and when I run the macro I get a message box
"This workbook contains links to other data sources..."
At which point it pauses waiting for a user to select Update or Don't Upate.
I would like this to select Update without any user intervention - is this possible?
Sincerely,
WageSlave101