I have a DBF (dBase table) file from which I need to create stacked-ba
charts -- one for every record in the table. In addition to all th
values and labels to appear on the graph, also stored in the DBF is
field which contains a unique filename used to save the created char
to a disk. Has anybody done this before using Excel/VBA? Could yo
perhaps post a sample of the code you used to accomplish this? Many
many thanks!

PS: I used to use DGE Graphics (DOS version) for this, but have lon
since lost the disks

--
Message posted from http://www.ExcelForum.com

Turn on the macro recorder (Tools | Macro > Record new macro...), open
the file, create a file based on one record, save the result using the
desired file name, and turn off the recorder. Share the code XL
generates (not as an attachment, please) together with some more
information about how many records are there in the file (or how to
recognize the last record) and, hopefully, someone will be able to
provide you with the necessary additional code to process all the
records.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <(E-Mail Removed)>, cjr01778
<<(E-Mail Removed)>> says...
> I have a DBF (dBase table) file from which I need to create stacked-bar
> charts -- one for every record in the table. In addition to all the
> values and labels to appear on the graph, also stored in the DBF is a
> field which contains a unique filename used to save the created chart
> to a disk. Has anybody done this before using Excel/VBA? Could you
> perhaps post a sample of the code you used to accomplish this? Many,
> many thanks!
>
> PS: I used to use DGE Graphics (DOS version) for this, but have long
> since lost the disks.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
>