the copy to is quick but there is some code before the copy to command is run. one file in particular takes a while because i do a couple of selects and replaces then finally the copy to.
Slán
~M
>>either
>>COPY TO "&lcFilename" type xls
>>or calling excel ole and watching the export depending on the users requirements
>>Slán
>>~M
>>>How You export the data?
>
>Mark,
>PMFJI but you said something like 1-2 mins if I saw right?
>Copy to ...
>just finishes instantly. 1-2mins rarely acceptable for excel. I wonder what it's taking so long (slow HW?). Maybe instead of a progress showing you need to optimize how you're doing it?
>Cetin
Go raibh maith agat
~M