I could implement a small function to import data submitted from the community inside the spreadsheet for new schematics, btw implementing it in excel 2007 is of no help (at least for me), actually I'm not going to change the version of the file anytime soon....this would require everyone to upgrade to excel 2007, since compatibility is not bidirectional (you can still adapt an old worksheet to a new version of the application, but you can't open a 2007 worksheeet with excel 2003).agida wrote:Hi all,
Was thinking of what it takes to add a new schematic to the SWGCtool and thought I'd start researching the best way to do that. This Excel 2007 spreadsheet is the first stage of the spreadsheet that only looks up the schematic and all the fields that are in the Schematic spreadsheet.
See this is just a look-up sheet any ideas or thoughts are welcome. BTW even though you could add a schematic unless Panino or I modify the behind the scenes VBA to handle added schematics. From what I've seen from Panino's modified code it looks like he takes into account changes to the schematic.
The other item that need updates in the other spreadsheets or required and optional components.
Stage II will be to actually add a new schematic to the sheet.
Stage III will be to add the required and optional components to the sheet(s).
Stage IV Check all the existing VBA code and coordinate with Panino if this is something we can add to the SWGCTool.
So for all those interested here's the spreadsheet http://www.swg-piloten.com/Schema_Maintenance_V0.1.zip
Anyway, the best way to import data inside the worksheet (using an automated function) is using a txt file with formatted text (comma separated), and not another worksheet, since opening a worksheet in the background is a bit more complicated (you have to avoid it remains open, so you have to close it properly, you have to check the sheets inside are what you're expecting, you have to validate the cells excc.....)