Submarine Reporter for Excel 2010 BETA 1.3 UPDATED 10/28/2011

[bk19@mweb.co.za]

PS.. it may well take a bit longer than winter just to come up with a model and software solution design.....

[rcm1616]

[/quote]
Agreed - I wonder it Richard would mind if I ported it to Java/C# or eventually into Tracker ?
[/quote]

That's great idea Damian! I had plan to develop new java version, but currently I'm overstacked with my work, family....
SubRep in Tracker - sounds like good idea. But to attach SubRep to CombatReporter maybe better idea.



Richard "Grimasa"

[bk19@mweb.co.za]

BUMP

ORIGINAL: bk19@mweb.co.za

To N01487477

I have a project in mind that will require some sophisticated academic skills.

How up to speed are you with Linear and Non-linear Programming in the context of Operations Management or the Quantitative Management domain?

[n01487477]

ORIGINAL: bk19@mweb.co.za

BUMP

ORIGINAL: bk19@mweb.co.za

To N01487477

I have a project in mind that will require some sophisticated academic skills.

How up to speed are you with Linear and Non-linear Programming in the context of Operations Management or the Quantitative Management domain?

Will reply by PM later today as I've got to get off to work now.

[seille]

Can you help with this?

I´m using 1.3 and followed your instructions, but when i simply open the sub tracker i get a
run time error, when i hit "debug" i get the screen you can see.

I changed the first tab as you wanted, but always get that same error.
Is there a typo in the code ?

[rcm1616]

ORIGINAL: seille

Can you help with this?

I´m using 1.3 and followed your instructions, but when i simply open the sub tracker i get a
run time error, when i hit "debug" i get the screen you can see.

I changed the first tab as you wanted, but always get that same error.
Is there a typo in the code ?

After 2 days of bugtracking with seille we identified problem as a bug in Excel 2007 version.
runtime error '40036' - some magic reason cause that excel did not read values from cells in opened worksheet.

There is a workaround - Mr. seille found it:

"Following a tip from the Internet i copied the Config Tab into a new tab and deleted the old one."

And it works!
[:)]

[seille]

Yeah, the program works very good and i like it a lot. Want to thank Grimasa for his help with setting up
and for making the tool. Too bad tools like this are not implemented in AE Tracker.

[Numdydar]

I cannot get this to work in Excel 2010 it keeps saying 'can't find project or library'

[nashvillen]

Switched to Excel 2013, also getting the "Can't find project or library"

What else is needed to make this work? Playing a game as allies, and would really like to see how my hordes of subs do.

[nashvillen]

Bump for those looking for this.

[EHansen]

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]

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

Code: Select all

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]

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]

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.