Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
without opening excel i want to save the excel in some specified location
Hi All, 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 Regards, Amar... -- areddy ------------------------------------------------------------------------ areddy's Profile: http://www.excelforum.com/member.php...o&userid=28204 View this thread: http://www.excelforum.com/showthread...hreadid=483439 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
without opening excel i want to save the excel in some specified location
Why not use
application.ScreenUpdating = False ' code that opens, populates the file, saves it to the appropriate location and closes it Application.ScreenUpdating = True msgbox "please refer your test.xls file from C:\Program Files\Admin folder" -- Regards, Tom Ogilvy "areddy" wrote in message ... Hi All, 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 Regards, Amar... -- areddy ------------------------------------------------------------------------ areddy's Profile: http://www.excelforum.com/member.php...o&userid=28204 View this thread: http://www.excelforum.com/showthread...hreadid=483439 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Excel - Save Location - Remember the folder | Excel Discussion (Misc queries) | |||
On Opening Excel WB the Active cell location never changes | Excel Discussion (Misc queries) | |||
have excel prompt for a file name and save location | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |