Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error message
Message
From
12/06/2007 05:09:01
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01232179
Message ID:
01232182
Views:
17
thank you for reply,
i need to open it just to rename one filed from any name to telno,

how i can close it ,to import it after rename(via vfp code),

i mean before
IMPORT FROM (thisform.text9.value) TYPE xls

thanks.

>Hi Mohammed,
>
>You cannot import from XLS sheet if openned.
>MartinaJ
>
>>hi all,
>>i try to convert excel sheet to dbf via this code...
>>i got erorr message OLE error code 0x80030020:ashare violation hase occurred.
>>
>>thanks for help
>>
>>
>>CLOSE all
>>SET DATE BRITISH
>>SET CENTURY on
>>thisform.text9.Value=GETFILE('xls')
>>**************************************************
>>   declare long ShellExecute in "shell32.dll" ;
>>	long hwnd, string lpszOp, ;
>>	string lpszFile, string lpszParams, ;
>>    string lpszDir, long nShowCmd
>>ShellExecute(0,'Open',thisform.text9.Value,'','',1)
>>********************************************************
>>IMPORT FROM (thisform.text9.value) TYPE xls &&&erorr message
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform