save active sheet..help needed

[onenessboy]

Hi experts,

For saving activesheet as seperate work i found the below code its working fine.
But at below line i hard coded the active sheet name. But i need code in such a way that, it should dynamically(through a variable) take name of what ever the current worksheet i am in. and while saving also it should take active current sheet name. Can some suggest the modification ..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Bob Phillips]

Please Login or Register  to view this content.

[onenessboy]

Please Login or Register  to view this content.

Hi Bob,

thank you for code..

but here i dont want to manually change the worksheet name.. i want code to pick up current active sheet ... any suggestions please

Please Login or Register  to view this content.