| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for chart in a worksheet
Hello,
I have a program that will allow me to input data on many sheets, in my workbook, from various testing that I do in a our lab. The program has a cmdbutton which executes a macro to generate an MSWord document. The macro cycles through each sheet in the activeworkbook and pulls data from cells and writes it to the Word application. As the macro cycles through each sheet I want it to check if there's a chart on that sheet and if so select and copy it to the Word document. Is that possible somewhere in VBA?? Thanks, Matt |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing for chart in a worksheet
Hi Matt,
Have a look at the ChartObject Msgbox "Activesheet contains " & _ Activesheet.ChartObjects.count & " charts" Cheers Andy MBaars wrote: Hello, I have a program that will allow me to input data on many sheets, in my workbook, from various testing that I do in a our lab. The program has a cmdbutton which executes a macro to generate an MSWord document. The macro cycles through each sheet in the activeworkbook and pulls data from cells and writes it to the Word application. As the macro cycles through each sheet I want it to check if there's a chart on that sheet and if so select and copy it to the Word document. Is that possible somewhere in VBA?? Thanks, Matt -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing for chart in a worksheet
Thanks Andy. I appreciate it.
Matt "Andy Pope" wrote: Hi Matt, Have a look at the ChartObject Msgbox "Activesheet contains " & _ Activesheet.ChartObjects.count & " charts" Cheers Andy MBaars wrote: Hello, I have a program that will allow me to input data on many sheets, in my workbook, from various testing that I do in a our lab. The program has a cmdbutton which executes a macro to generate an MSWord document. The macro cycles through each sheet in the activeworkbook and pulls data from cells and writes it to the Word application. As the macro cycles through each sheet I want it to check if there's a chart on that sheet and if so select and copy it to the Word document. Is that possible somewhere in VBA?? Thanks, Matt -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Chart Properties for Multiple Chart Shts using a Worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
| Testing for existence of a worksheet in the active workbook | Excel Programming | |||
| Testing for a open worksheet from Outlook | Excel Programming | |||
Linear Mode
