>Cetin,
>
>I was wondering if I could ask you a question regarding the code above (great function to copy data from VFP to Excel, thank you!).
>
>When I run your code it opens Excel and copies the data to a spreadsheet. But if I wanted to creat this spreadsheet in a specific folder under a specific name and not to open the spreadsheet, is it possible? In this case, where do I need to make changes in your code?
>
>Thank you.
Just remove WorkSheets(1).Activate() and visible and add
.ActiveWorkBook.SaveAs(m.lcExcelFile) at the end.
If it's not broken, fix it until it is.
My Blog