>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)
SET CPDIALOG OFF
use basket
censored.