View Single Post
  #1  
Old September 8th, 2009, 12:48 AM posted to microsoft.public.excel.charting
vbazen
external usenet poster
 
Posts: 1
Default Inserting charts into many workbooks

Hi,
I'm using Excel 2007 and am pretty new to VBA. I have a folder with 40
or so workbooks- all with the same worksheet table format. The worksheets
are huge (20 000 + rows, 50 or so columns). I need to open a workbook, make
several fully formatted graphs, then insert the same graphs into every
workbook , updated them with that workbooks' data.

Any ideas on code for this?