RE: Submarine Reporter for Excel 2010 BETA

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

RE: Submarine Reporter for Excel 2010 BETA

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Tech Support >> RE: Submarine Reporter for Excel 2010 BETA

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

Message

<< Older Topic Newer Topic >>

RE: Submarine Reporter for Excel 2010 BETA - 4/22/2014 2:16:25 AM

EHansen

Posts: 360
Joined: 12/6/2013
Status: offline

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?

(in reply to nashvillen)

Post #: 91

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

Flamingoes

Posts: 3
Joined: 6/20/2015
Status: offline

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.

< Message edited by Flamingoes -- 6/20/2015 4:40:26 AM >

(in reply to EHansen)

Post #: 92

RE: Submarine Reporter for Excel 2010 BETA - 11/25/2017 6:22:56 PM

Flamingoes

Posts: 3
Joined: 6/20/2015
Status: offline

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!

(in reply to Flamingoes)

Post #: 93

RE: Submarine Reporter for Excel 2010 BETA - 11/30/2017 4:57:48 PM

Wolfpack1

Posts: 32
Joined: 1/27/2008
From: Germany
Status: offline

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.

(in reply to Flamingoes)

Post #: 94

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

All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Tech Support >> RE: Submarine Reporter for Excel 2010 BETA