Programming Excel tru Access

[Patrice]

Hi,

I'd like to know why this line works in an Access module when I speak with
Excel

..
..
With objGra
..
..
..SetSourceData Source:=objSht.Range("A1:E" & intMaxRow + 1), _
PlotBy:=xlColumns

and not this one

..SetSourceData Source:=objSht.Range("A1:A" & intMaxRow + 1 & ", D1" _
& intMaxRow + 1), PlotBy:=xlColumns

Thank you

Patrice

 

[Michel Walsh]

Change intMaxRow tom, say, 10, and your last statement results into:


.SetSourceData Source:=objSht.Range("A1:A11, D111"), _
PlotBy:=xlColumns



I am not an expert in Excel, but I doubt that would work, it does, in Excel?
I got an #Name when I tried it, though I have no named range with the *name*
"A1:A11, D111"



Vanderghast, Access MVP

 

[Ralph]

..SetSourceData Source:=objSht.Range(objSht.Cells(1,1),objSht.Cells(" &
intMaxRow + 1 &",5)), PlotBy:=xlColumns

 

[Patrice]

the command works when the columns are in 1 bloc

..SetSourceData Source:=objSht.Range("A1:E75") PlotBy:=xlColumns

but not when the columns are separated

..SetSourceData Source:=objSht.Range("A1:A75, D175") PlotBy:=xlColumns

 

[Patrice]

I changed the , with ; (Juste before D1) and it's work. May be because my
system is in French? I'll check that

Thank you

SetSourceData Source:=objSht.Range("A1:A" & intMaxRow + 1 & ";D1" _
& intMaxRow + 1), PlotBy:=xlColumns