Tricks in CSV ?

[Robert Mills]

Chris,

What version of Excel are you using?
Is it on the Mac or Windows?
If Windows what version?
How are the files getting onto the PC?

If its on Win95+ via a terminal emulator (Reflection, Business Sessions,
etc) then why not use the scripting language within these programs to do it
for you. Reflection, especially version 7, is very easy to program as it
comes with VBA.

Regards,
Robert W.Mills (Windsong-Services)

-----Original Message-----
From: Chris Sharman [mailto:Chris.Sharman@ccagroup.co.uk]
Sent: Friday, April 07, 2000 4:58 PM
To: info-vax@mvb.saic.com; powerh-l@lists.swau.edu
Cc: Chris.Sharman@ccagroup.co.uk
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.