PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|need 2017 datas one by one using macro||12||38|
|Excel VBA Filter Results to different Worksheetd||21||35|
|Excel - Open a UserForm from a Custom Ribbon button with ribbonxml||5||17|
|Excel VBA Sort Toggle||5||14|