Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open an existing Excel file
Message
From
13/05/2005 10:39:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
13/05/2005 10:30:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01013850
Message ID:
01013855
Views:
18
>Hi everyone,
> I am working on a project where I am dumping info to an existing Excel spreadsheet, which is located on a local network, from multiple users though a VFP form. It works great however, I am worried when someone is in viewing this spreadsheet and someone else tries write to it, that I will lose the data. Is there a was to check and make sure that no one is using the spreadsheet before opening it and if there is someone using it then wait till they close it before it can be opened and the info can be inserted into it. I would like to have a message on the screen saying “Waiting… Spreadsheet is locked for editing by user_name”. I'm not sure if there is a property in the open command to handle this or not. Can someone help me with this? Thanks

If it's being edited you can't fopen() RW. Optionally you can use Open method's Notify parameter.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform