Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Yet more excel trouble
Message
De
31/01/2005 14:28:48
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
00980651
Message ID:
00982387
Vues:
47
>any idea why that would cause it to throw the C0000005 error on the open line?
>
>printing is required unfortunatly, these are jobsheets which are required for production rooms, I used to get the crash on the printline but I updated excel and the printdrivers and it stopped doing that, the only places it crashes now is on that open line and on the bit to select shaperange.
>
>so this line
>
>oworkbook = oExcel.workbooks.open(alltrim(basevars.baseljb) + "LaserJobbag.xls")
>
>
>or one of these lines
>
>oworkbook.worksheets(1).Shapes.selectall
>oexcel.selection.shaperange.visible = 0 && make copy graphic invisible
>
>
>and HERE is my crash

C...5 type errors *can* typically be attributed to referencing memory that doesn't belong to you or has been released. In this case, it may be something actually in the spreadsheet that's not 100% compatible with the version of Excel you're trying to open it in.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform