Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error code vfp and Excel
Message
From
28/03/2003 05:32:42
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00770958
Message ID:
00771219
Views:
7
>Hi,
>I am automating with vfp and excel spreadsheet when I get an error?
>
>Fatal error, exception code c000005
>line 131 Time and Date
>
>This line which I thought mimics me selecting two columns manually makes the error ??
>
>o.Application.Range("D:E").Select
>o.Application.Selection.EntireColumn.Insert
>
>but these do not
>
>o.Application.Range("D1").Select
>o.Application.Selection.EntireColumn.Insert
>o.Application.Range("D1").Select
>o.Application.Selection.EntireColumn.Insert

Steve,
Both worked on mine w/o error (VFP7 SP1, Excel 2000).
PS: Instead of a select and then insert, you could directly do in one shot (selection and range both return a range object) :

ox.ActiveWorkBook.ActiveSheet.Range("D:E").EntireColumn.Insert

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform