Zugg Software :: View topic

Novice Joined: 17 Oct 2002 Posts: 44 Location: USA

Is there a way to export values captured by trigger into individual cells/columns in an existing Excel spreadsheet?

>-Churlant-<

Posted: Tue Nov 26, 2002 7:02 pm

In the current public version thats a bit difficult (you'd probably need a plugin), but if you wait for the next version, or get the current Beta (6.37a), you can do it in a number of ways:
A write a VBScript alias, which starts Excel using 'Excel.Application' and writes to the cells (see the Excel VBA documentation for info).
Or write a VBA script in Excel which opens a zMUD object to get the values.

Note: A BETA version is prone to bugs, so if you decide to try it, make a Backup of your current version before you install it.

Lady C.

GURU Joined: 15 Jun 2001 Posts: 654 Location: USA

It should be possible to do this without scripting in the current public version; it merely requires the use of an intermediary format.

In the database module, go to the View menu, then to Export... From here you can export to a tab or comma separated text file, both of which can be imported by Excel.

In Excel 2000, the procedure for importing this is: Data, Get External Data, Import Text File..., select the file, go with the defaults until it asks where you want to put the data. Then click Properties, and don't have it save the query definition. This way, the spreadsheet is standalone and isn't tied to any specific file. Or you could not do this last step and have it so you could export the data to the same file in zMUD and just refresh the data in Excel. Depends on how you want to use it/how often it is updated.

- Charbal

Novice Joined: 17 Oct 2002 Posts: 44 Location: USA

The export wouldn't be an option.. I lost my copy of excel a while back and haven't gotten a new one.. the one I have at work is Excel 97.

What I'm attempting to do is collect information on the fly in the mud and enter it into a spreadsheet which is heavy on mathematical computations. Obviously I can do that with cut and paste, but I was curious to see if there would be a quicker and more automatic way of doing it.

Also, I know the ZMud db is capable of some math formulas, but even if the excel info could be translated (and a big if) I didn't create the excel sheet itself. Math on that level makes my head hurt :)

Anyway, thanks everyone for the suggestions.

>-Churlant-<