View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Macksey Ken Macksey is offline
external usenet poster
 
Posts: 77
Default application.visible problem

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