Community discussion forum

ActiveWorkbook.Worksheet

• • Reply

  2 years ago

  by acnetonline

  arne croughs

  Belgium, Belgium

  Joined 4 years ago
  I'm makin a script to make an inventory of what is in my computer and the problem is that this works:
  
  Set objblad = objExcel.ActiveWorkbook.Worksheets(1)
      objblad.Name = "Lokaal"
  set objblad2 = objExcel.activeworkbook.worksheets(2)
      objblad2.Name = "Processor"
  set objblad3 = objExcel.activeworkbook.worksheets(3)
      objblad3.Name = "OS & SP"
  
  Until i add:
  
  set objblad4 = objExcel.activeworkbook.worksheets(4)
      objblad4.Name = "Domein"
  
  I think it's got something to do with Excel having only 3 startup worksheets but i'm not sure.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Report abuse
• • Reply

  2 years ago

  by AndrewV

  AndrewV

  , United Kingdom

  Joined 4 years ago

  Sure is!!

  dunno if ur still looking for an answer but:

   

  worksheets.Add
  worksheets("Sheet4").name ="Domein"
  

  Report abuse
• • Reply

  2 years ago

  by acnetonline

  arne croughs

  Belgium, Belgium

  Joined 4 years ago
  I gave up on the project some time a go, but knowing this, i might give it another try, thank you
  
  
  Report abuse