Unanswered: without opening excel i want to save the excel in some specified location
Through vb iam populating some data from database and that data iam placing in excel by clicking the one button in vb application.
But for me I don't want to open the excel file when I click on the button. I want to place the excel file with data when I click on the button in some specific path(example - C:\Program Files\Admin folder\test.xls)
After placing the path it should display one message "please refer your test.xls file from C:\Program Files\Admin folder”
While clicking on the button it should not display the excel file. That should restrict.
Please help me on this