View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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