Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
With further testing, this part of the code seems to work ok, but the workbook name part does not. objxl.worksheets("sheet3").visible = true objxl.Application.displayalerts = false objxl.workbooks("Test x2.xls").save objxl.Application.displayalerts = True objxl.workbooks("Test x2.xls").close objxl.quit Maybe someone else knows how to get the workbook name with vb script. HTH Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Visible = False | Setting up and Configuration of Excel | |||
Application.Visible = False | Excel Discussion (Misc queries) | |||
Visible Instances of an Application | Excel Programming | |||
Runnig Excel without visible application | Excel Programming | |||
Application.visible help | Excel Programming |