To get around this problem, I need to create a copy of the Excel file. I
have tried using 'Save File', but this does not work on an open Excel
file. I have also tried using 'run command "xcopy..."'. While this
successfully copies the file, MapInfo does not wait for the xcopy
operation to finish, and so my application attempts to access the
spreadsheet file before xcopy has actually finished copying it.
Have you tried to include a pause after the xcopy command and before you try
to access the new file?
Dim start As Integer
start = Timer()
do
loop until (Timer() - start) > 10
Since mapbasic don't have a wait() command, the above lines can be used
(CPU-intensive......). You can probably also find a wait command somewhere
in the windows API.
Regards
Uffe
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16880
