Tricks in CSV ?

[Chris Sharman]

I'm generating .CSV files from Powerhouse (7.10.G3) on OpenVMS (7.1).

Ordinary data is no problem - Excel picks it up fine.
Formulae are also acceptable to Excel (A1 cell notation only).

We'd like to do:
	Use R[1]C[1] cell notation (doesn't seem to work at present).
	Set up pivot tables.
	Have Excel draw graphs.
	Create and/or execute macros.
	Any other ideas ??

All this, ideally, to be embedded into our CSV quiz report on VMS. In many
cases it's only a few mouse clicks, but some of our users are now getting to
spend most of Monday morning loading CSVs, doing those mouse clicks, and
saving them again as .xls.

Anyone know how to do this, or know who/where I should ask, or know it can't be
done ? I've looked for documentation on CSV, without much joy. Or is there a
better way to solve the problem ?

Many thanks,
Chris
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.ccastat.demon.co.uk/
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.