Charting DBF files in Excel using VBA?

  • Thread starter Thread starter cjr01778
  • Start date Start date
C

cjr01778

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
 
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
 
Back
Top