All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.
Dim i As Integer Dim bIsOpened For i = 1 To Application.Workbooks.Count bIsOpened = bIsOpened Or (Application.Workbooks(i).Name = "SALESORDERDOWNLOAD.XML" _ And Application.Workbooks(i).Path = "C:\_SAP\Extracts\SalesOrd") Next i If bIsOpened Then MsgBox "Target save file is open, Closing file so process can use it.", vbOKOnly + vbInformation, "Cannot have: C:\_SAP\EXTRACTS\SALESORD\SALESORDERDOWNLOAD.xml open and run this process. Close it and try again." Application.DisplayAlerts = False Windows("SALESORDERDOWNLOAD.XML").Activate ActiveWorkbook.Close Application.DisplayAlerts = True
|Execl - Adding user comments based on cell contents||5||32|
|cannot get subtotal to work||8||17|
|Dynamic Excel Countdown Graphic||21||15|
|How to check with VBA if an excel formula has multiple terms in it?||2||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
6 Experts available now in Live!