| Author |
Automating Chart Creation in Excel from Microsoft FoxPro
|
|
| Peter Aitken 2005-05-09, 8:25 pm |
| In an Excel workbook, I have a long macro in VBE that creates a chart and
sets properties of axes, series collections, etc.
I want to automate the process from within FoxPro. I copied the VBE code
into FoxPro and much of it works but not all. What do I need to know about
getting the VBE code to work from within FoxPro?
Any help will be gratefully received.
Thanls.
Peter
| |
| Mike Gagnon 2005-05-09, 8:25 pm |
| There aren't any written references. You have to 'translate' the code
yourself.
Here ias sample http://www.tek-tips.com/faqs.cfm?fid=4255
"Peter Aitken" < peter@benchmarkresea
rch.org> wrote in message
news:NVPfe.4041$f57.4013@trndny04...
> In an Excel workbook, I have a long macro in VBE that creates a chart and
> sets properties of axes, series collections, etc.
>
> I want to automate the process from within FoxPro. I copied the VBE code
> into FoxPro and much of it works but not all. What do I need to know about
> getting the VBE code to work from within FoxPro?
>
> Any help will be gratefully received.
>
> Thanls.
>
> Peter
>
| |
| Dan Freeman 2005-05-10, 11:24 am |
| Peter Aitken wrote:
> In an Excel workbook, I have a long macro in VBE that creates a chart
> and sets properties of axes, series collections, etc.
>
> I want to automate the process from within FoxPro. I copied the VBE
> code into FoxPro and much of it works but not all. What do I need to
> know about getting the VBE code to work from within FoxPro?
I wrote an article in the July 1999 issue of FoxPro advisor that shows the
basics of "what you need to know".
In a newsgroup, it's really easier to respond to specific questions.
Dan
| |
| Peter Aitken 2005-05-16, 7:25 am |
| Mike,
Thanks again for your help. Much appreciated.
Peter
"Mike Gagnon" <mgagnon23@hotmail.com> wrote in message
news:u$oXfgNVFHA.3572@TK2MSFTNGP12.phx.gbl...
> There aren't any written references. You have to 'translate' the code
> yourself.
> Here ias sample http://www.tek-tips.com/faqs.cfm?fid=4255
>
> "Peter Aitken" < peter@benchmarkresea
rch.org> wrote in message
> news:NVPfe.4041$f57.4013@trndny04...
>
>
| |
| Peter Aitken 2005-05-16, 7:25 am |
| Dan,
Thanks again for your help. Much appreciated.
Peter
"Dan Freeman" <spam@microsoft.com> wrote in message
news:%23yGzvZXVFHA.3544@TK2MSFTNGP12.phx.gbl...
> Peter Aitken wrote:
>
> I wrote an article in the July 1999 issue of FoxPro advisor that shows the
> basics of "what you need to know".
>
> In a newsgroup, it's really easier to respond to specific questions.
>
> Dan
>
>
|
|
|
|