• Home
  • About
  • Download
  • Tutorials

Build A List Macro (Excel) to Search Multiple Work Orders in Maximo

I like using SAP as you could select multiple rows of data, copy it to the clipboard and then use this list to search. However, in MAXIMO, it’s is not that easy.

Say you have a large list of Work Orders that you want to search and export that data to Excel to perform some other analysis, how would you do this? I recently came across a macro that can be used to do this and hope that you find this useful.

1. Save the excel file as a macro file *.xlsm file first.

2. Create a new macro by selecting: View, Macros, Record Macro. Make the Macro Name: “BuildList”. Created the Shortcut Key to whatever you want it to be. In this case, it was called “Ctrl + b”

3. Now edit the macro that was just created by the following navigation: view, macros, view macros, select the macro you just created “BuildList”, edit

 4. Remove all the code under General and replace with the following code:

'Sub BuildList()
'Dim Str As String
'Str = ""
    'For Each c In Range(ActiveWindow.RangeSelection.Address)
        'Str = Str & c.Value & ";"
    'Next c
'ActiveCell = Str
'MsgBox Str
'End Sub

Sub BuildList()
Dim Str, Cnt1, Cnt2, Sep As Variant
Dim DataObj As DataLabel

Cnt1 = 0
Cnt2 = 0
Str = "" 'Application.InputBox("Add a starting character, leave blank if none required")
Sep = Application.InputBox("Enter the seperator you require")
    For Each c In Range(ActiveWindow.RangeSelection.Address)
        Cnt1 = Cnt1 + 1
    Next c
    For Each c In Range(ActiveWindow.RangeSelection.Address)
        If Cnt2 < Cnt1 - 1 Then Str = Str & c.Value & Sep
        If Cnt2 = Cnt1 - 1 Then Str = Str & c.Value
        Cnt2 = Cnt2 + 1
    Next c

    'DataObj.SetText Str

    ActiveCell = Str
End Sub

5. Close the VB dialog box by clicking on the red X on the top hand corner:

6. Now redo the shortcut key: view, macros, select “BuildList” macro, options. Enter the letter “b” if you want your shortcut to be “Ctrl + b”, OK, red “X” on top right of macro dialog box.

7. Now paste the list of data in cell A1. In my case I have 10 rows of Work Order numbers:

8. Select the data you want, in my case cells A2 to A11, hit the shortcut key you chose, in my case “Ctrl + b”, enter “,=”, and hit OK

9. Now go to a notepad file and hit "Ctrl V". you should see the following result:

10. Essentially all we did was insert a “,=” after the first Work Order number. We could have done this with the “Concatenate” Excel function the long way round as well.

11. Now the 10 rows of data is in the clipboard with the “,=” inserted after the first Work Order number.

12. Go to your application…in my case Maximo. Go to the Work Order Tracking application, paste the Work Orders in the new format in the Find field and hit the binoculars button:

13. Go to the List Folder in Maximo and you should see the 10 works orders listed and you can export this to excel or wherever you want.


  1. You are the best ! Thanks

    1. Great Article Cloud Computing Projects

      Networking Projects

      Final Year Projects for CSE

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

  2. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it. The angular js programming language is very popular which are most widely used.

    Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery

  3. Such a very useful article. Very interesting to read this article. I would like to thank you for the efforts you had made for writing this awesome article.
    Data Science Course in Pune
    Data Science Training in Pune


  4. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.
    Ethical Hacking Course in Bangalore

  5. Thumbs up guys your doing a really good job. It is the intent to provide valuable information and best practices, including an understanding of the regulatory process.
    Cyber Security Course in Bangalore

  6. Very nice blog and articles. I am really very happy to visit your blog. Now I am found which I actually want. I check your blog everyday and try to learn something from your blog. Thank you and waiting for your new post.
    Cyber Security Training in Bangalore

  7. Wow! Such an amazing and helpful post this is. I really really love it. I hope that you continue to do your work like this in the future also.
    Ethical Hacking Training in Bangalore

  8. I am impressed by the information that you have on this blog. Thanks for Sharing
    Ethical Hacking in Bangalore

  9. I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    Data Science Training Institute in Bangalore

  10. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.\
    Best Data Science Courses In Bangalore

  11. Just saying thanks will not just be sufficient, for the fantasti c lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates.
    Data Science Course in Bangalore

  12. I am impressed by the information that you have on this blog. It shows how well you understand this subject.
    Data Science Training in Bangalore

  13. I have to search sites with relevant information ,This is a
    wonderful blog,These type of blog keeps the users interest in
    the website, i am impressed. thank you.
    pmp training in bangalore

  14. Incredibly in general very intriguing post. I was looking for such an information and took pleasure in scrutinizing this one. Keep posting. An obligation of appreciation is all together for analytics course in Hyderabad


Related Posts Plugin for WordPress, Blogger...