Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel, Foxpro, Error opening dbf
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00841422
Message ID:
00841433
Views:
21
>Hi, If I save an excell spreadsheet as a DBF and try to open that
>DBF immediately, I get an error: file access denied. On the other hand,
>if I insert a short delay after saving the file to dbf, no problem. Is
>there a better way to handle this problem?

I would replace your current delay with either an Inkey(2) or a Sleep(2000) so that the delay is consistent across CPU's with various speeds
o.Application.DisplayAlerts = 0
o.Application.ActiveWorkbook.SaveAs("C:\d\basket\basket.dbf",xlFileFormat)
o.Quit()

close all
use

Declare Sleep In Win32Api Integer
Sleep(2000)   && Wait two seconds.

SET CPDIALOG OFF
use basket
censored.
Previous
Reply
Map
View

Click here to load this message in the networking platform