RE: Submarine Reporter for Excel 2010 BETA

RE: Submarine Reporter for Excel 2010 BETA (Full Version)

All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Tech Support

Message

EHansen -> RE: Submarine Reporter for Excel 2010 BETA (4/22/2014 2:16:25 AM)
I can't get it to work with my Excel 2010. I did copy and paste the configuration sheet, then deleted the original sheet and that got rid of the 40036 error. But I am still getting an error, "cannot find project or library". Anyone know what I can do now?

Flamingoes -> RE: Submarine Reporter for Excel 2010 BETA (6/20/2015 12:56:07 AM)

That's the error I'm getting too. This is where the debugger stops it. (on the word Date in the 5th line)

Function GetDateSeparator() As String
    Dim MyStr As String
    Dim i As Long
    Dim b As Byte
    
    MyStr = Format(Date, "Short Date")
    GetDateSeparator = "?"
    
    For i = 1 To Len(MyStr)
        c = Mid(MyStr, i, 1)
        
        If Not IsNumeric(c) Then
            GetDateSeparator = c
            Exit For
        End If
    Next i
End Function

This is Excel 2007 on Windows 7 x64.

Flamingoes -> RE: Submarine Reporter for Excel 2010 BETA (11/25/2017 6:22:56 PM)
Success! 2.5 years later, I came back to this and I have gotten it to work. First, I had to do the new tab, move to the left, etc to get rid of the 40036 error. When you try to import the database and it errors out into Visual Basic for Applications, click Run > Reset, then Tools > References. I had two things listed there as MISSING (Microsoft Office Web Components 11.0 and Microsoft Common Dialog Control 6.0). I un-checked them and closed VBA and Excel, then relaunched it. That was what it took. Oh, also there seems to be a misspelling in the code. I had to change "MsgBoxResponsez" to MsgBoxResponse and save and close. Now, to figure out how to use it!

Wolfpack1 -> RE: Submarine Reporter for Excel 2010 BETA (11/30/2017 4:57:48 PM)
You are lucky. Cannot get it to work with Excel 2013. When I hit "Import Record" in the configuration sheet nothing happens, trying out "Import records from Archive" brings up "runtime Error 6 - overflow". The debugger shows code "AlreadyProcessed = AlreadyProcessed + 1". Do not know so much about VBA so I am stuck here. Maybe someone out here has an idea. So sad, looks like a really usefull tool.

Page: << < prev 1 2 3 [4]

0.59375