How To Insert Multiple Sheets in Calc Document through BASIC- Macro ? Any Code

[sv.thiyagarajan]

Hi Friends, Can Anybody show me the LO-Basic - Macro Code For " Insert Multiple Sheets " In Calc Document … In GUI Mode its Possible…Like below Screen Shots…

[JohnSUN]

Do you mean loop with .insertNewByName?

[sv.thiyagarajan]

Hi John Sun,
Without Loop - Any Code ?

[karolus]

Hallo

Sub Main

 sheets = thisComponent.Sheets
 for i = 3 to 10
  sheets.insertNewByName("funnyname" & i , sheets.Count )
 next 

End Sub

[sv.thiyagarajan]

Hi Karolus,

Thanks, Its working … But, “” With Out - Loop “” Is it possible any Code ? there…

[karolus]

@sv.thiyagarajan

“” With Out - Loop “” Is it possible any Code

NO IT IS NOT POSSIBLE WITHOUT LOOP!

[sv.thiyagarajan]

Thanks Karolus…