running macros under different workbook names?

[boyracer3000]

I have set up my workbook to run this nested macro:

Application.Run "'week-template.xls'!InsertRow"

Now I realise when saving the workbook under a different name this isn't going to work anymore. Is there a different way of coding this so that it will work. I'm thinking maybe to just pull the code out and paste into the macro it's currently in. Any ideas?

 

[SkipVought]

Hi,

You define a workbook object and set it to the workbook in question...

Dim wbkTemplate As Workbook

Set wbkTemplate = Workbooks("YourNewName.xls")

Application.Run "'" & wbkTemplate"'!InsertRow"

Seems to me that this should work. Skip,
metzgsk@voughtaircraft.com

 

[SkipVought]

Actually, this works...

    Dim wbkTemplate As Workbook
    Set wbkTemplate = Workbooks("TimeCard.xls")
    
    Application.Run wbkTemplate.Name & "!CopyRow"

Skip,
metzgsk@voughtaircraft.com

 

[boyracer3000]

Awesome I'll try this when I get home. Thanks for your help!