| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE - Chart.Wizard does not work in Office 2007
In the access program (97,2000,XP, 2003) I was using DDE commands for sending
data to Excel and creating charts. For the chart I was using Chart.Wizard which is faster than defining property by property the chart values. In 2007 this command is not executed. I don't receive an error but it does not work. Is this command not available in 2007 ? Has it been replaced by sth else ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DDE - Chart.Wizard does not work in Office 2007
Chris, I have run into the same problems with chart wizard and 2007. I
create charts now using code like: Charts.Add ActiveChart.ChartType = xlLineMarkers ActiveChart.SetSourceData Source:=tempR, PlotBy:=xlColumns ActiveChart.Location Whe=xlLocationAsObject, Name:=tempR.Parent.Name where I have defined tempR as a range variable for what is to be plotted Bob Flanagan Macro Systems 144 Dewberry Drive Hockessin, Delaware, U.S. 19707 Phone: 302-234-9857, cell 302-584-1771 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "chris" wrote in message ... In the access program (97,2000,XP, 2003) I was using DDE commands for sending data to Excel and creating charts. For the chart I was using Chart.Wizard which is faster than defining property by property the chart values. In 2007 this command is not executed. I don't receive an error but it does not work. Is this command not available in 2007 ? Has it been replaced by sth else ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DDE - Chart.Wizard does not work in Office 2007
Thanks a lot Bob for your message. I will try it. I hope is as fast as
chart.wizard. "Bob Flanagan" wrote: Chris, I have run into the same problems with chart wizard and 2007. I create charts now using code like: Charts.Add ActiveChart.ChartType = xlLineMarkers ActiveChart.SetSourceData Source:=tempR, PlotBy:=xlColumns ActiveChart.Location Whe=xlLocationAsObject, Name:=tempR.Parent.Name where I have defined tempR as a range variable for what is to be plotted Bob Flanagan Macro Systems 144 Dewberry Drive Hockessin, Delaware, U.S. 19707 Phone: 302-234-9857, cell 302-584-1771 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "chris" wrote in message ... In the access program (97,2000,XP, 2003) I was using DDE commands for sending data to Excel and creating charts. For the chart I was using Chart.Wizard which is faster than defining property by property the chart values. In 2007 this command is not executed. I don't receive an error but it does not work. Is this command not available in 2007 ? Has it been replaced by sth else ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wizard with Data Tracking template wont work in 2007 | Excel Discussion (Misc queries) | |||
| Office 2007 Configuration wizard runs every time I start anyApplication | Setting up and Configuration of Excel | |||
| OLAP Cube Wizard in Office 2007 | Excel Discussion (Misc queries) | |||
| Office 2007 Configuration wizard runs every time I start anyApplication (word, excel, etc) | Setting up and Configuration of Excel | |||
| Chart Wizard won't work | New Users to Excel | |||
Hybrid Mode
