Wulluby
New member
- Joined
- Apr 5, 2012
- Messages
- 7
- Reaction score
- 0
- Points
- 0
Hi,
I was just using the method described at Deploying Add-ins in a Network Environment to deploy an xlam add in.
I wanted to check the means of saving the xlam back to the development path as I think I may be misunderstanding what is happening, or why it is happening.
I get an error on
(.SaveAs Filename:=strAddinDevelopmentPath & .Name, _
ReadOnlyRecommended:=False)
Runtime error 1004: This extension can not be used.
I tried setting to this worksheet is an addin = true but it gave same error, tried to add FileFormat:=55 (I think 55 is xlam?) but get a compile error.
I guess my question is 2, how do I get round that? But also, if I take out the lines
( .SaveAs Filename:=strAddinDevelopmentPath & .Name, _
ReadOnlyRecommended:=False)
It still seems to save my xlam on the development path from the .save line above.
Thanks in advance for any pointers.
I was just using the method described at Deploying Add-ins in a Network Environment to deploy an xlam add in.
I wanted to check the means of saving the xlam back to the development path as I think I may be misunderstanding what is happening, or why it is happening.
I get an error on
(.SaveAs Filename:=strAddinDevelopmentPath & .Name, _
ReadOnlyRecommended:=False)
Runtime error 1004: This extension can not be used.
I tried setting to this worksheet is an addin = true but it gave same error, tried to add FileFormat:=55 (I think 55 is xlam?) but get a compile error.
I guess my question is 2, how do I get round that? But also, if I take out the lines
( .SaveAs Filename:=strAddinDevelopmentPath & .Name, _
ReadOnlyRecommended:=False)
It still seems to save my xlam on the development path from the .save line above.
Thanks in advance for any pointers.