View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E[_2_] AA2e72E[_2_] is offline
external usenet poster
 
Posts: 93
Default openning spreadsheet

Your button is executing

Set xlBook = xlApp.Workbooks.Open(strWorkbookName

every time it is pressed. You need to check whether the worbook is already open: if yes, don't open it otherwise open it