Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Yet more excel trouble
Message
From
31/01/2005 14:28:48
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00980651
Message ID:
00982387
Views:
50
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform