It doesn't make any sense to me!

In VB I have a worksheet and a chart (called MySheet and MyChart). I
need to move the chart from it's seperate sheet onto MySheet and can do
so using the following :-

MyChart.Location Whe=xlLocationAsObject,Name:=MySheet.Name

However when I do exactly the same process on a spreadsheet
created/running thru Microsoft Access. The chart is not placed on
MySheet, but on the first worksheet in the workbook. It is almost as if
Access (or Excel) is ignoring "Name" argument thru automation.

Does this sound familar to anyone, and if so how did you solve it?

Thanks in advance

----
Sean
"Just press the off switch, and go to sleep!"

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!