In Workbook running macro with relative path

Hi,

I have following macro in my file:

Sub Hide_button()
Application.Run "'Generic Order Form NEW_VERSION_template.xls'!hideUnhideZeros"
Application.Run "'Generic Order Form NEW_VERSION_template.xls'!Header"
Application.Run "'Generic Order Form NEW_VERSION_template.xls'!FontWhite"
End Sub

I would like the application to run also after I rename the file. I did look at the forums but couldn't find an answer to my question. : (
I would need something like this:
Application.Run "'ThisWorkbook.path'!Header"

Thanks for you help.

Regards,
George

Hi Roy,

Thanks for your reply.

Sadly I have no idea how I could create an addin

We use this quote form a lot and we always save it with different order numbers, but I can't figure out a way that I would have a relative path for the workbook.

Hope it makes sence ...

Thanks,
George

If the macros are in the same file, you don't need Application.Run at all:

Please Login or Register  to view this content.