How do I 'save-as' with an add-in .xla?
 

I created and saved an .xla file (a couple of custom functions) an
added it my add-ins. It is always open when I go the the VB editor an
works fine.

If I want to 'save-as' another name, how can I do this? The only optio
is the regular 'save'

--
thinkingfiel
-----------------------------------------------------------------------
thinkingfield's Profile: http://www.excelforum.com/member.php...fo&userid=1618
View this thread: http://www.excelforum.com/showthread.php?threadid=27609

How do I 'save-as' with an add-in .xla?
 

You can enter a SaveAs command in VBA's Immediate window. E.g.,

ThisWorkbook.SaveAs "NewName.xla"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"thinkingfield"
wrote in message
...

I created and saved an .xla file (a couple of custom functions)
and
added it my add-ins. It is always open when I go the the VB
editor and
works fine.

If I want to 'save-as' another name, how can I do this? The
only option
is the regular 'save'.


--
thinkingfield
------------------------------------------------------------------------
thinkingfield's Profile:
http://www.excelforum.com/member.php...o&userid=16181
View this thread:
http://www.excelforum.com/showthread...hreadid=276098

How do I 'save-as' with an add-in .xla?
 

--

HTH

RP
(remove nothere from the email address if mailing direct)


"thinkingfield" wrote in
message ...

I created and saved an .xla file (a couple of custom functions) and
added it my add-ins. It is always open when I go the the VB editor and
works fine.

If I want to 'save-as' another name, how can I do this? The only option
is the regular 'save'.


--
thinkingfield
------------------------------------------------------------------------
thinkingfield's Profile:
http://www.excelforum.com/member.php...o&userid=16181
View this thread: http://www.excelforum.com/showthread...hreadid=276098

How do I 'save-as' with an add-in .xla?
 

In the immediate window, use
Workbook("myAddin.xla").SaveAs Filename:="myOtherAddin.xla"



--

HTH


RP
(remove nothere from the email address if mailing direct)


"thinkingfield" wrote in
message ...

I created and saved an .xla file (a couple of custom functions) and
added it my add-ins. It is always open when I go the the VB editor and
works fine.

If I want to 'save-as' another name, how can I do this? The only option
is the regular 'save'.


--
thinkingfield
------------------------------------------------------------------------
thinkingfield's Profile:
http://www.excelforum.com/member.php...o&userid=16181
View this thread: http://www.excelforum.com/showthread...hreadid=276098