Week Number and current Hour

[Macdave_19]

Hi folks,

im a little stuck as ever!!!

the following code:

Please Login or Register  to view this content.

Basically it gets data from a database, sticks it in excel an renames the sheet, but i want to name the sheet as Follows:

Wk50Hr12

So basically the current Week number (50 at present) and the Current Hour (12 at the moment) but i don't know how i can achieve this.

please help folks!!!

thanks for reading

[AndySuk]

Hi

Is the problem renaming the sheet ro getting the hour returned?

activesheet.name="wk50hr12" will rename the tab OR
sheets(x).name="wk50hr12" where x is the sheet number

To get the hour you can use the hour function eg

this_hour=hour(now)

this will return an hour integer which you can use in the string for the name.

A