Tricks in CSV ?

[Walker, Chris]

Chris,

If the loading and clicking is the same every Monday then you could probably
automate it with Excel macros, or by controlling the Excel ActiveX object
from a program on the Windows box.

If the load actions vary with the data, then you might be able to write
script source (Windows Scripting Host, Perl etc) from Powerhouse to use
ActiveX to load the data.  This would give you complete control of Excel
from Powerhouse.

Chris Walker
Tate & Lyle
London


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