Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to prevent OLE-error
- Thread starter Nifrabar
- Start date
VolkerStamme
Programmer
Bart,
I think my Dutch goes far enough to understand that you're running into an access violation. Have you tried to open that very file in Excel before you attempted to open / create it again? If you export (as in COPY TO ... TYPE XLS) VFP will create a new file, i.e. open that file exclusively, which will conflict with Excel's import mechanism. Where about in your code are you exporting? If it is within an object of any sort (for instance a form) you can use the error event to catch that error, otherwise use ON ERROR DO myHandler WITH Error(). It's then up to you what to do with the error and no message will occur.
Volker/
I think my Dutch goes far enough to understand that you're running into an access violation. Have you tried to open that very file in Excel before you attempted to open / create it again? If you export (as in COPY TO ... TYPE XLS) VFP will create a new file, i.e. open that file exclusively, which will conflict with Excel's import mechanism. Where about in your code are you exporting? If it is within an object of any sort (for instance a form) you can use the error event to catch that error, otherwise use ON ERROR DO myHandler WITH Error(). It's then up to you what to do with the error and no message will occur.
Volker/
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
