Help needed on Excluding Weekends

[Elangovan89]

Hi All,

I need help to exclude Weekends when i run the macro.

Here the Code:

Please Login or Register  to view this content.

Thanks in advance!!!

Regards

Elango

[Solus Rankin]

Can you please post the whole script?

[Kiwoop]

you can use the function "weekday"

Please Login or Register  to view this content.

note :
sunday = 1
monday = 2
...

but you can change these defaults properties by the way

[Elangovan89]

Hi Solus,

Apologize for the delay post.

Please Login or Register  to view this content.

Hope above script will help..

Regards

Elango

[Elangovan89]

Hi Kiwoop,

Thanks for your code.

But still i am not clear about the code. I tried this code an error was occurred

Elango

[Solus Rankin]

Try:

Please Login or Register  to view this content.

Untested.

[Elangovan89]

Hi Solus,

Thanks for the try...

Macro is not working once i click the command button. I will look for some other alternative codes.

Elango

[Kiwoop]

Actually, you add a sheet with the date as name, and you dont want to add sheets for day which are on weekends is that right ?

The Xero Solus code should work I reckon. Which line do you get the error ?

[Elangovan89]

I found a code to avoid the Weekends.

Thanks

Elango