Ask Your Question
0

How do I create date-named sheets with macro

asked 2019-06-05 03:51:17 +0200

Isko106 gravatar image

updated 2019-06-05 03:53:50 +0200

Ratslinger gravatar image

It must be something like this except that the serial numbers are converted to a date.

Sub NameSheets


Sheets = ThisComponent.Sheets
Count = Sheets.Count
for i = 0 to Count - 1
    Sheet = Sheets.getByIndex(i)
    Sheet.Name = CStr(i + 43259)


next i

End Sub
edit retag flag offensive close merge delete

Comments

Edited for clarity. Please use toolbar icon preformatted text for this.

Ratslinger gravatar imageRatslinger ( 2019-06-05 03:56:06 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-06-05 06:04:59 +0200

You may use Format function for this.

edit flag offensive delete link more

Comments

wow, it worked. thanks!

Isko106 gravatar imageIsko106 ( 2019-06-05 11:48:59 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-06-05 03:51:17 +0200

Seen: 20 times

Last updated: Jun 05