if i open normal.xltm he names itself normal1.xltm, a problem with code?

[slaine06]

Hello,
I have a problem:if i open normal.xltm he names itself normal1.xltm, a problem with code?
Code:
Application.Run "normal.xltm!Filename"
Application.CutCopyMode = False
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
ActiveWorkbook.FullName, TextToDisplay:= _
ActiveWorkbook.FullName

It's a template in \Xlstart, do i need to use a variable for the "normal.xltm", and what's the variable???
Thanks in advance,

 

[RoryA]

Are you sure it's not normal1.xlSm? Why are you using a template file rather than a workbook file?

 

[slaine06]

Hello,
Do you think if it matters if i use xlsm or xltm???

I'm new in this substance so i don't know, i thought i needed xltm for templates

 

[RoryA]

xltm is a template but why are you trying to run a macro from a template?

 

[slaine06]

Hello,
Thanks for checking this out, my boss asked me to make a normal with macro to use it when excel opens.

 

[Norie]

I think you might want to get back to your boss and tell him there is no such thing as a 'normal' in Excel.

Now if we were talking Word there is the Normal.dot template.

What is it you are actually trying to do?

 

[RoryA]

I believe what you want is a Personal Macro Workbook. The easiest way to create one is to start to record a macro (you will need the Developer tab visible) and choose to save it in the Personal Macro Workbook, then just press Stop. This will create the workbook in the correct XLSTART directory. It will then load automatically when Excel starts (it will be hidden so you don't see it).

 

[slaine06]

Hello again...

My macro has to make a filename+path in a cell in excel and make a hyperlink of it and copy it to the clipboard ( to use it in outlook to paste the link), the macro works but now i want to put the file in a template that when i open excel i have my macro.
I hope that's clear for you???

Thanks, Slaine06

 

[slaine06]

but now i'm expieriencing a problem, that's what i told in the beginning of this thread.

 

[RoryA]

See my last response.