vasim
Member
I have five different users using different workbooks (front end); at the end of day they need to click “update database macro” which compiles all their data in a different workbook (back end).
Sub add_to_master_sheet()
If MsgBox("Update Database to reflect data from this file?", vbYesNo, "Add to Database") = vbYes Then
Application.ScreenUpdating = False
Workbooks.Open Filename:= _
"workaholixnew Rec-Reports backend.xlsm", writeresPassword:="password"
Workbooks("backend").Activate '(Error throws up here)
Sheets("Database").Select
‘more codes
End sub
For all the user the code is working fine except at one of them, it throws up an error as “Run-time error 9: Subscript out of range”.
If the same file(error one) is used from other PC (shared network) it works fine.
If any other users front end sheet is updated from her desk it throws up an error.
Any help please??
PS: I have checked the workbook name...its the same...and thats why doesnt have a problem while opening but only when activating...
Sub add_to_master_sheet()
If MsgBox("Update Database to reflect data from this file?", vbYesNo, "Add to Database") = vbYes Then
Application.ScreenUpdating = False
Workbooks.Open Filename:= _
"workaholixnew Rec-Reports backend.xlsm", writeresPassword:="password"
Workbooks("backend").Activate '(Error throws up here)
Sheets("Database").Select
‘more codes
End sub
For all the user the code is working fine except at one of them, it throws up an error as “Run-time error 9: Subscript out of range”.
If the same file(error one) is used from other PC (shared network) it works fine.
If any other users front end sheet is updated from her desk it throws up an error.
Any help please??
PS: I have checked the workbook name...its the same...and thats why doesnt have a problem while opening but only when activating...