Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extracting a few cells from an excel spreadsheet
Message
From
20/01/2009 01:01:07
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01371276
Message ID:
01375363
Views:
9
Something like below:-

oExcel.workbook.CLOSE

oExcel.QUIT()
RELEASE oExcel && release the object

>Quick question related to this post.
>
>When I am done importing info from Excel using the previous code I cannot open the spreadsheet later because Excel says the file is Locked for Editing by me.
>
>How do you unlock the file so people can use the spreadsheet?
>
>I used:
>oExcel.quit()
>oExcel = .null.
>
>But neither unlocks it.
Regards N Mc Donald
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform