Army List and Label Generator - Download - Version 1.04

General discussion forum for anything related to Field of Glory Napoleonics.

Moderators: philqw78, terrys, hammy, Blathergut, Slitherine Core

Chasseur
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 544
Joined: Wed Jan 21, 2009 7:42 am
Location: Melbourne, Australia
Contact:

Re: Army List and Label Generator - Download - Version 1.04

Post by Chasseur »

Hi,

"part Lancer" and part other Cavalry is what I mean by mixed Cavalry.
I have some more testing to do before I can release it.

Cheers,
John
Stu
Private First Class - Wehrmacht Inf
Private First Class - Wehrmacht Inf
Posts: 8
Joined: Wed Jun 20, 2012 7:23 pm
Location: Auckland, New Zealand

Re: Army List and Label Generator - Download - Version 1.04

Post by Stu »

Don't know if it's me or not... both versions are not opening in OpenOffice (3.3.0) and my Android tablet thinks it's a virus.

In OpenOffice the 2010 version it don't get a 'New Army' button. And on the 2003 version when I click on the button I get-
"A Scripting Framework error occurred while running the UNKNOWN script UNKNOWN.
Incorrect format for Script URI"
On Android (both Gingerbread and Ice Cream Sandwich) the anti virus kicks in thinking there is a problem, scans the document with no problems then shuts it down...

Any suggestions?

Stu :)
Chasseur
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 544
Joined: Wed Jan 21, 2009 7:42 am
Location: Melbourne, Australia
Contact:

Re: Army List and Label Generator - Download - Version 1.04

Post by Chasseur »

Hi,

This was written for Excel. It uses a lot of Visual Basic (VBA) programming in the background and array formulas in some of the cells to achieve all it does, especially the generation of the labels.
Because this is more than just a spreadsheet with formulas, Open Office does not have the capability to convert the program properly.
Sorry but it will not work properly with Open Office. :(

Cheers,
John Shaw
Stu
Private First Class - Wehrmacht Inf
Private First Class - Wehrmacht Inf
Posts: 8
Joined: Wed Jun 20, 2012 7:23 pm
Location: Auckland, New Zealand

Re: Army List and Label Generator - Download - Version 1.04

Post by Stu »

Any chance of 'sharing' that VB script??? :)

....only becouse I don't know much VB, but my Dad does (what he does for a job) and it wouldn't take much to work it into a HTML/Java based envirnoment (something I can do). That way us wierdos with Linux/Unix machines can use it too! In fact anything with a web browser could run it (in theory).
And even neater, I could run it on my Android tablet; which this reply is being typed on. I've almost merged all my DBR stuff across...

Stu :)
Blathergut
Field Marshal - Elefant
Field Marshal - Elefant
Posts: 5875
Joined: Tue Jan 22, 2008 1:44 am
Location: Southern Ontario, Canada

Re: Army List and Label Generator - Download - Version 1.04

Post by Blathergut »

Power(s) that be: Could this be stickied?
terrys
Panzer Corps Team
Panzer Corps Team
Posts: 4226
Joined: Thu Mar 16, 2006 11:53 am

Re: Army List and Label Generator - Download - Version 1.04

Post by terrys »

Power(s) that be: Could this be stickied?
Yes!
LeslieMitchell
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 240
Joined: Tue Aug 11, 2009 6:29 am

Re: Army List and Label Generator - Download - Version 1.04

Post by LeslieMitchell »

:)
LeslieMitchell
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 240
Joined: Tue Aug 11, 2009 6:29 am

Re: Army List and Label Generator - Download - Version 1.04

Post by LeslieMitchell »

Chasseur wrote:Hi,

"part Lancer" and part other Cavalry is what I mean by mixed Cavalry.
I have some more testing to do before I can release it.

Cheers,
John

Any update on this option release?
Jilu
Sergeant Major - Armoured Train
Sergeant Major - Armoured Train
Posts: 560
Joined: Sun Jan 17, 2010 12:14 pm

Re: Army List and Label Generator - Download - Version 1.04

Post by Jilu »

has anyone managed to make a Open Office army generator?

thx,

Jilu
LeslieMitchell
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 240
Joined: Tue Aug 11, 2009 6:29 am

Re: Army List and Label Generator - Download - Version 1.04

Post by LeslieMitchell »

Chasseur wrote:Hi,

"part Lancer" and part other Cavalry is what I mean by mixed Cavalry.
I have some more testing to do before I can release it.

Cheers,
John

And any update on this option?
RexGator
Private First Class - Wehrmacht Inf
Private First Class - Wehrmacht Inf
Posts: 5
Joined: Wed Oct 03, 2012 5:04 pm

Re: Army List and Label Generator - Download - Version 1.04

Post by RexGator »

At the risk of some embarrasment to myself, would someone mind explaining to me how you use the labels that print out of the Army Sheet. I had envisioned something tiny that you affix to the rear edge of each base. What I see is substantially larger. Do people put there bases on top of the label with just the lower portion remaining visible? Or do the labels not go on the table at all?
KendallB
Sergeant First Class - Elite Panzer IIIL
Sergeant First Class - Elite Panzer IIIL
Posts: 416
Joined: Fri Sep 18, 2009 9:01 pm
Location: North Shore, New Zealand

Re: Army List and Label Generator - Download - Version 1.04

Post by KendallB »

There are a few terrain combinations that need to be added like Eastern Europe and Southern Europe for one.

I love this though!
deadtorius
General - Carrier
General - Carrier
Posts: 4960
Joined: Mon Oct 20, 2008 12:41 am

Re: Army List and Label Generator - Download - Version 1.04

Post by deadtorius »

RexGator wrote:At the risk of some embarrasment to myself, would someone mind explaining to me how you use the labels that print out of the Army Sheet. I had envisioned something tiny that you affix to the rear edge of each base. What I see is substantially larger. Do people put there bases on top of the label with just the lower portion remaining visible? Or do the labels not go on the table at all?
I think there is a link with a picture showing them in use, you place your base on top of them with the back of the label sticking out.
Stu
Private First Class - Wehrmacht Inf
Private First Class - Wehrmacht Inf
Posts: 8
Joined: Wed Jun 20, 2012 7:23 pm
Location: Auckland, New Zealand

Re: Army List and Label Generator - Download - Version 1.04

Post by Stu »

Jilu wrote:has anyone managed to make a Open Office army generator?
thx,
Jilu
"Stay tuned this station" as the saying goes....
...trying to work something out, when not being distracted by figure painting/ordering

Stu. :)
RexGator
Private First Class - Wehrmacht Inf
Private First Class - Wehrmacht Inf
Posts: 5
Joined: Wed Oct 03, 2012 5:04 pm

Re: Army List and Label Generator - Download - Version 1.04

Post by RexGator »

Or maybe an iOS friendly version?
Jilu
Sergeant Major - Armoured Train
Sergeant Major - Armoured Train
Posts: 560
Joined: Sun Jan 17, 2010 12:14 pm

Re: Army List and Label Generator - Download - Version 1.04

Post by Jilu »

ok

i use

http://www.libreoffice.org/

much better than openoffice as it runs macros
pugsville
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 223
Joined: Tue Jan 15, 2013 5:42 am
Location: Melbourne, Australia

Re: Army List and Label Generator - Download - Version 1.04

Post by pugsville »

When using libre office you need to set the macros allowed option, I think it's in the security settings, the Army List side works fine after that. (cant make the label generator work though).


Also the Army Lost dont allow Heavy Shock Cavalry with Lancers! (Yup blatant discrimination against us ottoman types! I dont think anyone else can have them)
pugsville
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 223
Joined: Tue Jan 15, 2013 5:42 am
Location: Melbourne, Australia

Re: Army List and Label Generator - Download - Version 1.04

Post by pugsville »

using libre office tools > options > security > macro security > low

And the actual list part works fine (cant generate labels though)
Post Reply

Return to “Field of Glory : Napoleonic Era 1792-1815 : General Discussion”