Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel won't 'listen'
Message
From
12/08/2003 03:54:16
Geert Van Snik
Zorgned Automatisering Bv
Wageningen, Netherlands
 
 
To
08/08/2003 08:26:24
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00818096
Message ID:
00819268
Views:
24
Hi Cetin,

Thank you for the response, but I don't understand the benefit of this.
Our application doesn't need to update the data in the sheet, it's a sort of snapshot. Therefor I feel I should be able to use a fixed hardcoded range for my SeriesCollection.
And it's all just fine, unless the selection of the data from the datasheet is smaller that 3 rows. In that case Excel decides that C5:Fx should be D5:Fx.
Furthermore I'm lazy ;) So if the data is correct on my datasheet and I tell Excel which range it should pick up from the data sheet it should do just that.

In general I think that either generating the range (as is done in your code) or hardcoding the range doesn't resolve this (I still have to try your code)

I'll get back on this, but I think it's a bug in the automation.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform