I have the following code in a macro that open a server file, extract specific data and locate it in the this user file.
HTML Code:
Sub getvalue()
Dim Path, myrange, ShName, Wb As String
Path = "\\Server Folder"
Wb = "Report-1c-Server.xlsx"
myrange = "A9:C9700"
Workbooks.Open Filename:=Path & "\" & Wb
With ThisWorkbook.Sheets("EXHIBIT 6-A") 'change sheet1 to your sheet name
.Activate
Select Case ThisWorkbook.Sheets("EXHIBIT 6-A").Cells(5, "S")
Case 7
ShName = "Arxxx-MP-July"
ActiveSheet.Cells(7, "B") = Application.VLookup(ActiveSheet.Cells(4, "G"),
Workbooks(Wb).Sheets(ShName).Range(myrange), 3, False)
Case Else
End Select
End With
Workbooks(Wb).Close , savechanges = True
End Select
End Sub
Currently, the server file appears on the taskbar when the code opens it to extract the required data.
Although, the server file is not editable, is there a way to not make it appear on the taskbar ( hid it)? I appreciate your support.
Thank you.