Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run the macros without opening or showing the excel sheet
Hi friends, I need to find out How we can shedule the wokrbook to run the macros without opening the excel application. When i put application.visible = false . The application is running in the task manger ...without ending If i use option as "workbook.close" It's asking " do u want to save the changes in the excel" and also it's showing the excel application..not the work book .. Can any one tell me how to write the code for this .? Thanks -- psk ------------------------------------------------------------------------ psk's Profile: http://www.excelforum.com/member.php...o&userid=15738 View this thread: http://www.excelforum.com/showthread...hreadid=273343 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run the macros without opening or showing the excel sheet
Hi
use application.displayalerts=false activeworkbook.save application.quit 'or 'activeworkbook.close -- Regards Frank Kabel Frankfurt, Germany "psk" schrieb im Newsbeitrag ... Hi friends, I need to find out How we can shedule the wokrbook to run the macros without opening the excel application. When i put application.visible = false . The application is running in the task manger ...without ending If i use option as "workbook.close" It's asking " do u want to save the changes in the excel" and also it's showing the excel application..not the work book .. Can any one tell me how to write the code for this .? Thanks -- psk --------------------------------------------------------------------- --- psk's Profile: http://www.excelforum.com/member.php...o&userid=15738 View this thread: http://www.excelforum.com/showthread...hreadid=273343 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a worksheet without showing excel components | Excel Worksheet Functions | |||
Message "class not registered" opening sheet with macros Excel 97 | Excel Discussion (Misc queries) | |||
"Icons" not showing when opening up Chart Wizard in Excel 2003 | Charts and Charting in Excel | |||
macros not showing up when using excel COM object in .NET | Excel Programming | |||
Excel VBA question - showing userform when opening workbook | Excel Programming |