We have over 10 computers on our network and everyone's computer opens up the file with no issue. Even this one computer that is having it automatically close on open used to have it work without a problem until this morning. I created a copy of the file to see if it was the file that was corrupted but when the copy is opened the same thing happens. Does anyone have any idea why this would start happening, I do not see any problems with the code. The computers are operating on windows 10 pro. Here is the code that runs on open, it is only supposed to close workbook x but it is closing y as well only on his computer starting today.
Private Sub Workbook_Open()
Dim x As Workbook
Dim y As Workbook
Dim z As Integer
Set x = Workbooks.Open(Filename:="*FilePath*", ReadOnly:=True)
Set y = Workbooks("MonthlyLog")
x.Sheets("Distribution Lists").Range("A2:F1200").Copy
y.Sheets("Distribution Lists").Range("A124:F1322").PasteSpecial
Application.CutCopyMode = False
x.Close
If month(Now) = 1 Then
z = 12
Else
z = month(Now) - 1
End If
Sheets(MonthName(z)).Activate
Application.Calculation = xlManual
End Sub
It isn't asking to repair anything just prompting to save right upon opening and if Save or Do Not Save are chosen then it closes, only when cancel is clicked it stays open.
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)