Macro button refrencing issue?

[zabiullakhan]

I have a template Worksheet where i have added macro into the template.

This template worksheet changes name everyday depending on the date but the macro writen in the template refrence to the old worksheet..
how can i overcome this and refrence the macro to the activeworksheet irrespective of name change.

Please help..

 

[GlennUK]

Can you describe exactly how this is happening ....

the macro writen in the template refrence to the old worksheet

?

 

[zabiullakhan]

Yes..

 

[zabiullakhan]

This is my template worksheet

file name - Template.xlsm
macro refrence - 'Template.xlsm'!RefreshData
 
new file made
 
file name - Template_march_21_2011.xlsm
macro refrence - 'C:\data\Template'!RefreshData 
 
however i want macro refrence to change automatically as below
 
file name - Template_march_21_2011.xlsm
macro refrence - Template_march_21_2011.xlsm'!RefreshData

 

[GlennUK]

I want to know what references you are talking about. Where are these references that you want to be changing automatically?

 

[zabiullakhan]

when we write a macro we do assign a button to a macro on that sheet.

That refrence of the button and the macro.

 

[GlennUK]

What type of button? Is this button embedded in a worksheet?

 

[zabiullakhan]

yes button to trigger the macro..