Page 5 of 5
RE: Submarine Reporter for Excel 2010 BETA
Posted: Mon Jan 02, 2012 2:09 pm
by 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.....
RE: Submarine Reporter for Excel 2010 BETA
Posted: Tue Jan 03, 2012 4:11 am
by 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"
RE: Submarine Reporter for Excel 2010 BETA
Posted: Tue Jan 03, 2012 12:41 pm
by 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?
RE: Submarine Reporter for Excel 2010 BETA
Posted: Tue Jan 03, 2012 9:18 pm
by 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.
RE: Submarine Reporter for Excel 2010 BETA
Posted: Sun Oct 06, 2013 11:03 am
by 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 ?
RE: Submarine Reporter for Excel 2010 BETA
Posted: Tue Oct 08, 2013 7:38 am
by 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!
[:)]
RE: Submarine Reporter for Excel 2010 BETA
Posted: Tue Oct 08, 2013 12:11 pm
by 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.
RE: Submarine Reporter for Excel 2010 BETA
Posted: Wed Dec 11, 2013 3:38 pm
by Numdydar
I cannot get this to work in Excel 2010 it keeps saying 'can't find project or library'
RE: Submarine Reporter for Excel 2010 BETA
Posted: Mon Dec 30, 2013 10:06 pm
by 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.
RE: Submarine Reporter for Excel 2010 BETA
Posted: Mon Apr 21, 2014 8:21 pm
by nashvillen
Bump for those looking for this.
RE: Submarine Reporter for Excel 2010 BETA
Posted: Mon Apr 21, 2014 11:16 pm
by 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?
RE: Submarine Reporter for Excel 2010 BETA
Posted: Fri Jun 19, 2015 9:56 pm
by 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.
RE: Submarine Reporter for Excel 2010 BETA
Posted: Sat Nov 25, 2017 4:22 pm
by 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!
RE: Submarine Reporter for Excel 2010 BETA
Posted: Thu Nov 30, 2017 2:57 pm
by 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.