Tricks in CSV ?

[Robert J.M. Edis]

G'day Chris

Sounds like a job for Impromptu.  It will read your data directly, use
macros, run as a scheduled job, create pivot table/s, draw graphs and make
you breakfast to boot! :)

Blue 

-----Original Message-----
From: Chris Sharman
To: info-vax@mvb.saic.com; powerh-l@lists.swau.edu
Cc: Chris.Sharman@ccagroup.co.uk
Sent: 4/7/00 11:58 AM
Subject: Tricks in CSV ?

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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.