Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error code vfp and Excel
Message
De
28/03/2003 05:32:42
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00770958
Message ID:
00771219
Vues:
8
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform