Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Automating Excel
From:	Mike McNeil Computer Troubleshooters Queenstown <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 26 Mar 2003 16:32:18 +1200
Content-Type:	text/plain
Parts/Attachments:	text/plain (23 lines)

Hi Aumor,

Not sure if I fully understand your question, but if all you want to do is
write the vba code to open the histogram, you can just record a new macro,
select the defaults you want, and then open the macro with the Excel VBA
editor (unhide the personal.xls first if this is where you saved the macro.
via Window/unhide). You will then see the vb code used. You can paste this
code into another macro if you wish.

Regards
Mike McNeil


To automate Excel how would you call an Excel defined function eg Histogram
(found under tools, data analysis) in a VBA procedure (with all its
parameters)?
Any help provided would be appreciated
Aumor

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG