Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Share violation error on IMPORT of .XLS ?
Message
From
03/12/2003 21:50:20
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
03/12/2003 13:17:43
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00855531
Message ID:
00855710
Views:
20
It seems that sometimes the operating system keeps the file marked as "in use", accidentally, even after you close it.

See if you can open the file with Excel, and if you can rename it, for instance.

Also, try rebooting the operating system. The above-mentioned circumstance usually gets solved by rebooting.

>I have code in one of my .VCX sub-classes (forms):
>
>FileSrcXls=_DIR_DD_XLS+"dd_mmLoad_data.xls"
>IF FILE(FileSrcXls)
> import from (FileSrcXls) XLS
>
>
>The debugger is stopping on import statement with error message:
>
>OLE error code 0x80030020: A share violation has occurred.
>
>I do NOT have Microsoft Excel open with that worksheet file active.
>Why is this message being thrown, and what can I do to stop it from
>coming up?
>
>DBK
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform