Topic
2 replies Latest Post - ‏2013-02-21T17:04:45Z by SystemAdmin
GaryK
GaryK
1 Post
ACCEPTED ANSWER

Pinned topic nmon-analyzer run-time error 52

‏2013-02-13T11:34:31Z |
Hi ALL,

can you suggest how to solve problem.
nmon-analyzer
MS Office 2007 SP1 MSO
nmon-analyzer from 28 aug 2012(latest from officeal site)

Thank you in advance,
Igor
Updated on 2013-02-21T17:04:45Z at 2013-02-21T17:04:45Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    2402 Posts
    ACCEPTED ANSWER

    Re: nmon-analyzer run-time error 52

    ‏2013-02-21T16:52:49Z  in response to GaryK
    I'm getting the same error with versions 33g and 34a of analyzer.
    Windows 7 64bit and excel 2010.

    The debugger shows the problem here on If Filename entry:

    '================= Build filelist ====================================
    Numfiles = 0
    Set MyCells = Worksheets(1).Range("FileList").Offset(0, -1)
    If Filename = "" Or Dir(Filename) = "" Then <--------------------- This is where it shows the error
    'get the names of the files to process
    FileList = Application.GetOpenFilename("NMON Files(*.csv;.nmon),.csv;*.nmon", 1, "Select NMON file(s) to be processed", , True)
    If VarType(FileList) <> vbBoolean Then Numfiles = UBound(FileList)
    'write them to the sheet for sorting
    If Numfiles = 0 Then Exit Sub
    For i = 1 To Numfiles
    MyCells.Offset(i, 0) = FileList(i)
    Next
    Else
  • SystemAdmin
    SystemAdmin
    2402 Posts
    ACCEPTED ANSWER

    Re: nmon-analyzer run-time error 52

    ‏2013-02-21T17:04:45Z  in response to GaryK
    I was able to get through it on 33g version by saving 33g as a new macro type file on save as options, reloaded it and it worked. I tried the samed thing on 34a but it had an error during the load "ZZZZ |sort " failed (using all defaults).