Hi,
To avoid warning messages in Excel try:

oXls.Application.DisplayAlerts = .f.

This will suppress any warning dialogs and for dialogs that require a response, Excel chooses the default response.

You may want to check Message #462095 for another example to copy data from VFP to Excel. It uses COPY TO TYPE FOX2X then SaveAs() to save the file in Excel format. In my experience this approach is much faster than using DataToClip().


>I have been experimenting with using DATATOCLIP() and a program Fred Taylor posted in message #461978 to transfer VFP table data to Excel and I had two questions someone might have an opinion on.
>
>First, is there a trustworthy way to know how large a segment of data can be cut and pasted using DATATOCLIP() on any given workstation? Just because I can paste 5000 records at a time does that mean everyone else can?
>
>Second, the VFP table I've been experimenting with has a first name field in it with some duplicate names. As data is being pasted into Excel, a dialog form pops up labeled "Identify Label" telling me that there is more than one cell with the label of the duplicated name, and asking me to "Select the cell containing the label to use" - if I cancel out of this it doesn't seem to have any harmful effect, but is there a way to suppress these kinds of warnings from Excel?
>
>Thanks